Answer-first summary for fast verification
Answer: Schedule the query to refresh every day from the query’s page in Databricks SQL.
The optimal approach for scheduling a SQL query for daily data completeness checks in Databricks SQL, particularly when the output is utilized across multiple dashboards, is to schedule the query to refresh every day directly from the query’s page in Databricks SQL. This method is preferred because: - **Direct Scheduling from Query Page**: It offers a straightforward and integrated solution specifically designed for this purpose. - **Dashboard Integration**: Scheduled refreshes ensure that dashboards automatically reflect the latest data, maintaining consistency. - **Jobs UI vs. Query Page**: While the Jobs UI is suitable for complex workflows, the query’s page is ideal for queries linked to dashboards, simplifying management. - **SQL Endpoints**: These are generally used for serving data to external applications, making them less suitable for this scenario. - **Frequency**: A daily schedule meets the requirement without imposing unnecessary load. Steps to schedule: 1. Navigate to the query info tab. 2. Click the link adjacent to **Refresh Schedule** to access the schedule intervals picker. 3. Configure the schedule, selecting an appropriate interval and time if necessary, with adjustments for UTC timezone considerations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To ensure daily data completeness checks via a SQL query in Databricks SQL, which method is most efficient for scheduling when the query's output feeds into multiple dashboards?
A
Schedule the query to run every 12 hours from the Jobs UI.
B
Schedule the query to refresh every day from the SQL endpoint’s page in Databricks SQL.
C
Schedule the query to refresh every day from the query’s page in Databricks SQL.
D
Schedule the query to run every day from the Jobs UI.
E
Schedule the query to refresh every 12 hours from the SQL endpoint’s page in Databricks SQL.
No comments yet.