Explanation:
To set up a schedule for refreshing queries automatically in Databricks SQL, follow these steps:
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.
Ultimate access to all questions.
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.
No comments yet.