Databricks

Usage Instructions

Connect to Databricks to execute SQL queries against SQL warehouses, trigger and monitor job runs, manage clusters, and retrieve run outputs. Requires a Personal Access Token and workspace host URL.

Tools

`databricks_execute_sql`

Execute a SQL statement against a Databricks SQL warehouse and return results inline. Supports parameterized queries and Unity Catalog.

Input

Parameter	Type	Required	Description
`host`	string	Yes	Databricks workspace host (e.g., dbc-abc123.cloud.databricks.com)
`apiKey`	string	Yes	Databricks Personal Access Token
`warehouseId`	string	Yes	The ID of the SQL warehouse to execute against
`statement`	string	Yes	The SQL statement to execute (max 16 MiB)
`catalog`	string	No	Unity Catalog name (equivalent to USE CATALOG)
`schema`	string	No	Schema name (equivalent to USE SCHEMA)
`rowLimit`	number	No	Maximum number of rows to return
`waitTimeout`	string	No	How long to wait for results (e.g., "50s"). Range: "0s" or "5s" to "50s". Default: "50s"

Output

Parameter	Type	Description
`statementId`	string	Unique identifier for the executed statement
`status`	string	Execution status (SUCCEEDED, PENDING, RUNNING, FAILED, CANCELED, CLOSED)
`columns`	array	Column schema of the result set
`data`	array	Result rows as a 2D array of strings where each inner array is a row of column values
`totalRows`	number	Total number of rows in the result
`truncated`	boolean	Whether the result set was truncated due to row_limit or byte_limit

`databricks_get_statement`

Poll a SQL statement by its ID to retrieve status and results. Use this after Execute SQL when a query runs longer than the wait timeout.

Input

Parameter	Type	Required	Description
`host`	string	Yes	Databricks workspace host (e.g., dbc-abc123.cloud.databricks.com)
`apiKey`	string	Yes	Databricks Personal Access Token
`statementId`	string	Yes	The ID of the statement to fetch (returned by Execute SQL)

Output

Parameter	Type	Description
`statementId`	string	Unique identifier for the statement
`status`	string	Execution status (SUCCEEDED, PENDING, RUNNING, FAILED, CANCELED, CLOSED)
`columns`	array	Column schema of the result set
`data`	array	Result rows as a 2D array of strings where each inner array is a row of column values
`totalRows`	number	Total number of rows in the result
`truncated`	boolean	Whether the result set was truncated due to row_limit or byte_limit

`databricks_list_warehouses`

List all SQL warehouses in a Databricks workspace including their size, state, and type. Use this to discover the warehouse ID needed for Execute SQL.

Input

Parameter	Type	Required	Description
`host`	string	Yes	Databricks workspace host (e.g., dbc-abc123.cloud.databricks.com)
`apiKey`	string	Yes	Databricks Personal Access Token

Output

Parameter	Type	Description
`warehouses`	array	List of SQL warehouses in the workspace

`databricks_list_jobs`

List all jobs in a Databricks workspace with optional filtering by name.

Input

Parameter	Type	Required	Description
`host`	string	Yes	Databricks workspace host (e.g., dbc-abc123.cloud.databricks.com)
`apiKey`	string	Yes	Databricks Personal Access Token
`limit`	number	No	Maximum number of jobs to return (range 1-100, default 20)
`offset`	number	No	Offset for pagination
`name`	string	No	Filter jobs by exact name (case-insensitive)
`expandTasks`	boolean	No	Include task and cluster details in the response (max 100 elements)

Output

Parameter	Type	Description
`jobs`	array	List of jobs in the workspace
`hasMore`	boolean	Whether more jobs are available for pagination
`nextPageToken`	string	Token for fetching the next page of results

`databricks_get_job`

Get the full definition and settings of a single Databricks job by its job ID.

Input

Parameter	Type	Required	Description
`host`	string	Yes	Databricks workspace host (e.g., dbc-abc123.cloud.databricks.com)
`apiKey`	string	Yes	Databricks Personal Access Token
`jobId`	number	Yes	The canonical identifier of the job to retrieve

Output

Parameter	Type	Description
`jobId`	number	The job ID
`name`	string	Job name
`creatorUserName`	string	Email of the job creator
`runAsUserName`	string	User the job runs as
`createdTime`	number	Job creation timestamp (epoch ms)
`format`	string	Job format (SINGLE_TASK or MULTI_TASK)
`maxConcurrentRuns`	number	Maximum number of concurrent runs
`timeoutSeconds`	number	Job-level timeout in seconds (0 or null means no timeout)
`schedule`	object	Cron schedule configuration (quartz_cron_expression, timezone_id, pause_status)
`tags`	object	Key-value tags applied to the job
`tasks`	array	Task definitions for the job (empty for single-task jobs)

`databricks_run_job`

Trigger an existing Databricks job to run immediately with optional job-level or notebook parameters.

Input

Parameter	Type	Required	Description
`host`	string	Yes	Databricks workspace host (e.g., dbc-abc123.cloud.databricks.com)
`apiKey`	string	Yes	Databricks Personal Access Token
`jobId`	number	Yes	The ID of the job to trigger
`jobParameters`	string	No	Job-level parameter overrides as a JSON object (e.g., {"key": "value"})
`notebookParams`	string	No	Notebook task parameters as a JSON object (e.g., {"param1": "value1"})
`idempotencyToken`	string	No	Idempotency token to prevent duplicate runs (max 64 characters)

Output

Parameter	Type	Description
`runId`	number	The globally unique ID of the triggered run
`numberInJob`	number	The sequence number of this run among all runs of the job

`databricks_get_run`

Get the status, timing, and details of a Databricks job run by its run ID.

Input

Parameter	Type	Required	Description
`host`	string	Yes	Databricks workspace host (e.g., dbc-abc123.cloud.databricks.com)
`apiKey`	string	Yes	Databricks Personal Access Token
`runId`	number	Yes	The canonical identifier of the run
`includeHistory`	boolean	No	Include repair history in the response
`includeResolvedValues`	boolean	No	Include resolved parameter values in the response

Output

Parameter	Type	Description
`runId`	number	The run ID
`jobId`	number	The job ID this run belongs to
`runName`	string	Name of the run
`runType`	string	Type of run (JOB_RUN, WORKFLOW_RUN, SUBMIT_RUN)
`attemptNumber`	number	Retry attempt number (0 for initial attempt)
`state`	object	Run state information
`startTime`	number	Run start timestamp (epoch ms)
`endTime`	number	Run end timestamp (epoch ms, 0 if still running)
`setupDuration`	number	Cluster setup duration (ms)
`executionDuration`	number	Execution duration (ms)
`cleanupDuration`	number	Cleanup duration (ms)
`queueDuration`	number	Time spent in queue before execution (ms)
`runPageUrl`	string	URL to the run detail page in Databricks UI
`creatorUserName`	string	Email of the user who triggered the run

`databricks_list_runs`

List job runs in a Databricks workspace with optional filtering by job, status, and time range.

Input

Parameter	Type	Required	Description
`host`	string	Yes	Databricks workspace host (e.g., dbc-abc123.cloud.databricks.com)
`apiKey`	string	Yes	Databricks Personal Access Token
`jobId`	number	No	Filter runs by job ID. Omit to list runs across all jobs
`activeOnly`	boolean	No	Only include active runs (PENDING, RUNNING, or TERMINATING)
`completedOnly`	boolean	No	Only include completed runs
`limit`	number	No	Maximum number of runs to return (range 1-24, default 20)
`offset`	number	No	Offset for pagination
`runType`	string	No	Filter by run type (JOB_RUN, WORKFLOW_RUN, SUBMIT_RUN)
`startTimeFrom`	number	No	Filter runs started at or after this timestamp (epoch ms)
`startTimeTo`	number	No	Filter runs started at or before this timestamp (epoch ms)

Output

Parameter	Type	Description
`runs`	array	List of job runs
`hasMore`	boolean	Whether more runs are available for pagination
`nextPageToken`	string	Token for fetching the next page of results

`databricks_cancel_run`

Cancel a running or pending Databricks job run. Cancellation is asynchronous; poll the run status to confirm termination.

Input

Parameter	Type	Required	Description
`host`	string	Yes	Databricks workspace host (e.g., dbc-abc123.cloud.databricks.com)
`apiKey`	string	Yes	Databricks Personal Access Token
`runId`	number	Yes	The canonical identifier of the run to cancel

Output

Parameter	Type	Description
`success`	boolean	Whether the cancel request was accepted

`databricks_get_run_output`

Get the output of a completed Databricks job run, including notebook results, error messages, and logs. For multi-task jobs, use the task run ID (not the parent run ID).

Input

Parameter	Type	Required	Description
`host`	string	Yes	Databricks workspace host (e.g., dbc-abc123.cloud.databricks.com)
`apiKey`	string	Yes	Databricks Personal Access Token
`runId`	number	Yes	The run ID to get output for. For multi-task jobs, use the task run ID

Output

Parameter	Type	Description
`notebookOutput`	object	Notebook task output (from dbutils.notebook.exit())
`error`	string	Error message if the run failed or output is unavailable
`errorTrace`	string	Error stack trace if available
`logs`	string	Log output (last 5 MB) from spark_jar, spark_python, or python_wheel tasks
`logsTruncated`	boolean	Whether the log output was truncated

`databricks_list_clusters`

List all clusters in a Databricks workspace including their state, configuration, and resource details.

Input

Parameter	Type	Required	Description
`host`	string	Yes	Databricks workspace host (e.g., dbc-abc123.cloud.databricks.com)
`apiKey`	string	Yes	Databricks Personal Access Token

Output

Parameter	Type	Description
`clusters`	array	List of clusters in the workspace

`databricks_get_cluster`

Get the state, configuration, and resource details of a single Databricks cluster by its cluster ID.

Input

Parameter	Type	Required	Description
`host`	string	Yes	Databricks workspace host (e.g., dbc-abc123.cloud.databricks.com)
`apiKey`	string	Yes	Databricks Personal Access Token
`clusterId`	string	Yes	The ID of the cluster to retrieve

Output

Parameter	Type	Description
`cluster`	object	Cluster detail

Notes

Category: tools
Type: databricks

Databricks

On this page