Explanation:
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:
Steps to schedule:
Ultimate access to all questions.
No comments yet.
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.