SQL task for jobs
Use the SQL task type to configure a SQL query, legacy dashboard, alert, or SQL file.
The SQL task requires Databricks SQL and a serverless or pro SQL warehouse.
Configure a SQL task
Before you begin, you must have your SQL asset in a location accessible by the user configuring the job.
Note
The jobs UI displays options dynamically based on other configured settings.
To begin the flow to configure a SQL
task:
Navigate to the Tasks tab in the Jobs UI.
In the Type drop-down menu, select
SQL
.
Configure the SQL task type
In the SQL task drop-down menu, select a SQL task type using one of the following options.
Legacy dashboard
Select a Legacy dashboard to update using the specified SQL warehouse.
(Optional) Add Subscribers to send a report with the updated dashboard.
Alert
Select a SQL alert to evaluate using the specified SQL warehouse.
(Optional) Add Subscribers to notify with the results of the alert.
File
Use File to run a .sql
file using the specified SQL warehouse.
The file can contain multiple SQL statements separated by semicolons (;
).
You must configure a Source for the SQL file using one of the following options.
Workspace
Use Workspace to configure a SQL file stored as a workspace file.
Click the Path field. The Select SQL file dialog appears.
Browse to the SQL file, click to highlight the file, and click Confirm.
Note
You can use this option to configure a task for a SQL file stored in a Databricks Git folder. Databricks recommends using the Git provider option with a remote Git repository to version assets scheduled with jobs.
Git provider
Use Git provider to configure a SQL file stored in a remote Git repository.
The options displayed by the UI depend on whether or not you have already configured a Git provider elsewhere. Only one remote Git repository can be used for all tasks in a job. See Use Git with jobs.
The Path field appears after you have configured a git reference.
Enter the relative path for your notebook, such as etl/bronze/ingest.sql
.
Important
When you enter the relative path, don’t begin with /
or ./
. For example, if the absolute path for the notebook you want to access is /etl/bronze/ingest.sql
, enter etl/bronze/ingest.sql
in the Path field.
Finalize job configuration
(Optional) Configure Parameters as key-value pairs referenced in the configured SQL asset. Alerts do not support parameters. See Configure task parameters.
Click Save task.