A data engineer adds a SQL task to a Lakeflow Jobs job to run a saved query after the nightly load. Which compute can this task use?
Choose an answer to check it. Afterward, select any option to review its explanation.
SQL tasks run on Databricks SQL and need a serverless or pro SQL warehouse; the query, alert or file runs against the warehouse selected in the task.
Job clusters serve tasks such as notebooks and scripts; a SQL task needs a SQL warehouse instead of a cluster.
Any SQL warehouse may seem acceptable, but the SQL task requirement names only serverless or pro warehouses, so a classic one does not qualify.
All-purpose clusters run notebooks and other code tasks, but a SQL task is configured against a SQL warehouse.
id q00ba51db23