Explanation:
The program can be implemented in a Python notebook or task that checks the day of week and conditionally executes the final query. This allows the preceding queries to run every day while the final query runs only when the condition is true. Permissions and data-model changes are not scheduling mechanisms.
A SQL program contains several queries that must run daily, but only the final query should run on Sundays. Which approach can implement this behavior?
A
Submit a feature request to Databricks.
B
Wrap the queries in PySpark and use Python control flow to run the final query conditionally.
C
Run the entire program only on Sundays.
D
Restrict access to the source table so it is accessible only on Sundays.
E
Redesign the data model and place the final query’s data in a new table.
No comments yet.