Answer-first summary for fast verification
Answer: Schedule the query to refresh every 1 day from the query’s page in Databricks SQL.
To set up a schedule for refreshing queries automatically in Databricks SQL, follow these steps: 1. Navigate to the query info tab. 2. Click the link next to 'Refresh Schedule' to open the schedule interval picker. 3. Select your desired schedule interval (ranging from 1-30 minutes, 1-12 hours, 1 or 30 days, 1 or 2 weeks) and time if applicable. 4. Confirm by clicking 'OK'. Note: The time selector appears only for intervals greater than 1 day and day selections beyond 1 week. Scheduled times are converted from your local timezone to UTC. For queries not executing as scheduled, manual triggering is advised to check for failures. Be mindful that manual executions can affect the scheduled intervals and times. For more details, refer to the [Databricks SQL documentation](https://docs.microsoft.com/en-us/azure/databricks/sql/user/queries/schedule-query).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
To automate the process of reviewing data quality and monitoring ETL jobs daily with SQL queries in Databricks, which of the following scheduling approaches can be utilized?
A
Schedule the query to run every 12 hours from the Jobs UI.
B
Schedule the query to refresh every 1 day from the SQL endpoint’s page in Databricks SQL.
C
Schedule the query to refresh every 12 hours from the SQL endpoint’s page in Databricks SQL.
D
Schedule the query to run every 1 day from the Jobs UI.
E
Schedule the query to refresh every 1 day from the query’s page in Databricks SQL.