Use Databricks to execute parameterized SQL, manage jobs and runs, control compute clusters and SQL warehouses, and work with Genie spaces. Connect with a saved Databricks connection, which holds the workspace host and how Sim signs in.
SQL operations return inline JSON rows, including SQL nulls. If a statement is still running, poll Get Statement. Follow nextChunkIndex with Get Statement Chunk to retrieve additional rows, or use Cancel Statement to stop execution. Configure rowLimit and byteLimit for predictable result sizes; external-link and Arrow/CSV downloads are outside these SQL operations.
Create, update, reset, or delete jobs; run saved jobs or submit one-time workloads. Get Run exposes task run IDs, resolved task values, repair history, and pagination. Use a task run ID with Get Run Output, and Repair Run to rerun failed tasks. Most job requests use Jobs API 2.2; existing offset pagination and notebook parameter overrides retain Jobs 2.1 compatibility. List operations return one page: pass nextPageToken back as pageToken to continue.
Cluster operations support creating, configuring, starting, restarting, resizing, terminating, and permanently deleting compute. Warehouse operations support configuration, scaling, starting, stopping, and deletion. Nested settings use Databricks API field names in JSON inputs, while dedicated inputs use the names listed below.
Genie operations create and update spaces, answer natural-language questions, manage conversation history, and retrieve generated SQL, results, and charts. Reuse the conversation ID for follow-ups. Use a space's etag when updating it to avoid overwriting concurrent changes. Agent mode supports research reports and response cancellation; it must be enabled in your workspace.
Connection guides: Databricks connections.
Use the block
Execute parameterized SQL and retrieve result chunks, create and manage jobs, submit and repair runs, manage compute clusters and SQL warehouses, and create or update Genie spaces. Ask Genie questions or run agent research, inspect conversations, and retrieve query results and charts.
Actions
Databricks Execute SQL
Execute a SQL statement against a Databricks SQL warehouse and return results inline. Supports parameterized queries and Unity Catalog.
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.
Databricks Get Statement Chunk
Retrieve one chunk of an INLINE SQL result using nextChunkIndex from Execute SQL or Get Statement.
Databricks Cancel Statement
Request cancellation of an executing SQL statement; poll Get Statement to confirm its final status.
Databricks List Jobs
List all jobs in a Databricks workspace with optional filtering by name.
Databricks Get Job
Get the full definition and settings of a single Databricks job by its job ID.
Databricks Create Job
Create a Databricks job with tasks, scheduling, execution identity, and notifications.
Databricks Update Job
Merge selected settings into a Databricks job and optionally remove settings or tasks.
Databricks Reset Job
Replace all settings of a Databricks job.
Databricks Delete Job
Delete a Databricks job and cancel its active runs.
Databricks Run Job
Trigger an existing Databricks job to run immediately with optional job-level or notebook parameters.
Databricks Submit Run
Submit a one-time task run without creating a saved job.
Databricks List Runs
List job runs in a Databricks workspace with optional filtering by job, status, and time range.
Databricks Get Run
Get the status, timing, and details of a Databricks job run by its run ID.
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).
Databricks Repair Run
Rerun failed or selected tasks within an existing Databricks run.
Databricks Cancel Run
Cancel a running or pending Databricks job run. Cancellation is asynchronous; poll the run status to confirm termination.
Databricks Cancel All Runs
Request cancellation of active runs of a job or queued runs in the workspace.
Databricks Delete Run
Delete a completed Databricks job run.
Databricks List Clusters
List a page of clusters in a Databricks workspace including their state, configuration, and resource details.
Databricks Get Cluster
Get the state, configuration, and resource details of a single Databricks cluster by its cluster ID.
Databricks Create Cluster
Create a compute cluster with runtime, sizing, policy, and cloud-specific settings.
Databricks Edit Cluster
Replace a compute cluster configuration; a running cluster restarts to apply the changes.
Databricks Start Cluster
Start a terminated all-purpose compute cluster.
Databricks Restart Cluster
Restart a running compute cluster.
Databricks Resize Cluster
Change the fixed worker count or autoscaling range of a running cluster.
Databricks Terminate Cluster
Terminate a compute cluster while retaining its configuration for a later restart.
Databricks Delete Cluster
Permanently delete a compute cluster and its configuration.
Databricks List Warehouses
List a page of SQL warehouses in a Databricks workspace including their size, state, and type. Use this to discover the warehouse ID needed for Execute SQL.
Databricks Get Warehouse
Get the configuration, state, and scaling settings of a SQL warehouse.
Databricks Create Warehouse
Create a SQL warehouse with sizing, autoscaling, and serverless settings.
Databricks Edit Warehouse
Update a SQL warehouse configuration.
Databricks Start Warehouse
Start a stopped SQL warehouse.
Databricks Stop Warehouse
Stop a running SQL warehouse.
Databricks Delete Warehouse
Delete a SQL warehouse.
Databricks Genie List Spaces
List the Genie spaces (Genie agents) you can access. Use this to find the space ID needed to ask Genie a question.
Databricks Genie Get Space
Get a Genie space's title, description, and SQL warehouse, optionally with its full configuration export (tables, instructions, sample questions).
Databricks Create Genie Space
Create a Genie space from its serialized configuration and a SQL warehouse.
Databricks Update Genie Space
Update a Genie space, optionally protecting the change with its current ETag.
Databricks Trash Genie Space
Move a Genie space to the trash.
Databricks Genie Ask
Ask a Databricks Genie space a question in natural language and wait for the answer. Starts a new conversation, or continues an existing one when a conversation ID is given. Returns the text answer, the SQL Genie generated, and the query result rows.
Databricks Genie Get Message
Get a Genie message's status and answer, including the generated SQL, visualizations, and suggested follow-up questions.
Databricks Genie List Messages
List the messages in a Genie conversation with their answers and generated SQL, for example to replay a conversation history.
Databricks Genie Get Query Result
Get the rows returned by the SQL query Genie generated for a message. Available once the message is EXECUTING_QUERY or COMPLETED.
Databricks Genie Execute Query
Re-run the SQL query Genie generated for a message. Use this when the message's query result has expired (status QUERY_RESULT_EXPIRED). If the returned status is PENDING or RUNNING, fetch the rows afterwards with Get Genie Query Result.
Databricks Genie Download Visualization
Download a chart Genie generated as a PNG image, for example to post it to Slack. The message must be COMPLETED and asked with visualization enabled. Not supported on Private Link workspaces.
Databricks Genie Send Feedback
Rate a Genie answer as positive or negative, with an optional comment. Space authors use this feedback to improve the space's instructions.
Databricks Genie Delete Message
Delete a message from a Genie conversation.
Databricks Genie List Conversations
List conversations in a Genie space, including whether each is a chat-mode or agent-mode conversation. By default only your own conversations are returned.
Databricks Genie Delete Conversation
Delete a Genie conversation you no longer need.
Databricks Genie Agent Ask
Ask a Genie agent a question in agent mode, where Genie plans multi-step research, runs several SQL queries, and writes a report with citations. Waits for the final report. Starts a new agent-mode conversation, or continues one when a conversation ID is given. Agent mode is in preview and must be enabled on the workspace.
Databricks Genie Agent List Items
List an agent-mode conversation's full history in order: questions, reasoning, SQL calls, query results, and reports. Agent mode is in preview and must be enabled on the workspace.
Databricks Genie Agent Cancel
Cancel an in-flight Genie agent response using the response ID returned by the agent stream.