Databricks

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

1. 01

   Create a free account

   Sign up at sim.ai in seconds. No credit card required. Your workspace is ready immediately.

2. 02

   Add a Databricks block

   Open a workflow, drag a Databricks block onto the canvas, and paste in your Databricks API key.

3. 03

   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.

Supported tools

8 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.

• List Jobs

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

• 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.

Frequently asked questions