Answer-first summary for fast verification
Answer: From the Queries page in Databricks SQL, schedule the query to run every week.
To automate query execution in Databricks SQL, you can schedule it directly from the Queries page. This allows you to set intervals (e.g., weekly) and specific times for the query to run, ensuring your dashboards and alerts are up-to-date. The schedule is set in your local timezone and converted to UTC by Databricks SQL. For instance, to run a query at 00:00 UTC, adjust the schedule according to your local timezone offset. This feature is essential for routine data processing and sharing with teams.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A data engineer needs to automate the weekly execution of a query in Databricks SQL for data processing to share with the analysis team. Which method should they use?
A
Schedule the query from the Alerts page in Databricks SQL for weekly refreshes.
B
Use the Workflows UI to set up the query for automatic weekly execution.
C
There is no functionality to automatically refresh a query in Databricks SQL.
D
From the Queries page in Databricks SQL, schedule the query to run every week.
E
Configure the query to refresh weekly via the Dashboards page in Databricks SQL.