SQL File Task

SQL File Task

Usage

sql_file_task(path, warehouse_id, source = NULL, parameters = NULL)

Arguments

path

Path of the SQL file. Must be relative if the source is a remote Git repository and absolute for workspace paths.

warehouse_id

The canonical identifier of the SQL warehouse.

source

Optional location type of the SQL file. When set to WORKSPACE, the SQL file will be retrieved from the local Databricks workspace. When set to GIT, the SQL file will be retrieved from a Git repository defined in git_source() If the value is empty, the task will use GIT if git_source() is defined and WORKSPACE otherwise.

parameters

Named list of paramters to be used for each run of this job.

See also

Other Task Objects: condition_task(), email_notifications(), for_each_task(), libraries(), new_cluster(), notebook_task(), pipeline_task(), python_wheel_task(), run_job_task(), spark_jar_task(), spark_python_task(), spark_submit_task(), sql_query_task()