Overview
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.
How to automate Databricks with Sim
Create a free account
Sign up at sim.ai in seconds. No credit card required. Your workspace is ready immediately.
Add a Databricks block
Open your workspace, drag a Databricks block onto the workflow builder, and paste in your Databricks API key.
Configure, connect, and run
Pick the tool you need, wire in an AI agent for reasoning or data transformation, and run. Your Databricks automation is live.
Agent templates
Ready-to-use templates featuring Databricks. Click any to build it instantly.
Supported tools
12 Databricks tools available in Sim
Execute SQL
Execute a SQL statement against a Databricks SQL warehouse and return results inline. Supports parameterized queries and Unity Catalog.
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.
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.
List Jobs
List all jobs in a Databricks workspace with optional filtering by name.
Get Job
Get the full definition and settings of a single Databricks job by its job ID.
Run Job
Trigger an existing Databricks job to run immediately with optional job-level or notebook parameters.
Get Run
Get the status, timing, and details of a Databricks job run by its run ID.
List Runs
List job runs in a Databricks workspace with optional filtering by job, status, and time range.
Cancel Run
Cancel a running or pending Databricks job run. Cancellation is asynchronous; poll the run status to confirm termination.
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).
List Clusters
List all clusters in a Databricks workspace including their state, configuration, and resource details.
Get Cluster
Get the state, configuration, and resource details of a single Databricks cluster by its cluster ID.
Frequently asked questions
Sim's Databricks integration lets you build AI agents that automate tasks in Databricks without writing code. Run SQL queries and manage jobs on Databricks. You can connect Databricks to hundreds of other services in the same agent — from CRMs and spreadsheets to messaging tools and databases.
Start automating Databricks today
Build your first AI agent with Databricks in minutes. Connect to every tool your team uses. Free to start, no credit card required.