Run SQL, manage jobs, and ask Genie agents on Databricks
Databricks is a Sim integration in the Databases category. Sim is the AI workspace where teams build and deploy AI agents. Sim's Databricks integration provides 26 tools that AI agents can use inside Sim's visual workflow builder. Databricks connects with an API key. Free to start at sim.ai.
Last updated
Connect to Databricks to execute SQL queries against SQL warehouses, trigger and monitor job runs, manage clusters, and retrieve run outputs. Ask Genie spaces (Genie agents) questions in natural language and get back answers, the generated SQL, result rows, and charts, continuing a conversation across follow-ups, or run Genie agent mode for multi-step research reports. Requires a Personal Access Token and workspace host URL.
Sign up at sim.ai in seconds. No credit card required. Your workspace is ready immediately.
Open your workspace, drag a Databricks block onto the workflow builder, and paste in your Databricks API key.
Pick the tool you need, wire in an AI agent for reasoning or data transformation, and run. Your Databricks automation is live.
Ready-to-use templates featuring Databricks. Click any to build it instantly.
26 Databricks tools available to Sim agents.
Execute a SQL statement against a Databricks SQL warehouse and return results inline. Supports parameterized queries and Unity Catalog.
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 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 all jobs in a Databricks workspace with optional filtering by name.
Get the full definition and settings of a single Databricks job by its job ID.
Trigger an existing Databricks job to run immediately with optional job-level or notebook parameters.
Get the status, timing, and details of a Databricks job run by its run ID.
List job runs in a Databricks workspace with optional filtering by job, status, and time range.
Cancel a running or pending Databricks job run. Cancellation is asynchronous; poll the run status to confirm termination.
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 all clusters in a Databricks workspace including their state, configuration, and resource details.
Get the state, configuration, and resource details of a single Databricks cluster by its cluster ID.
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.
Get a Genie message's status and answer, including the generated SQL, visualizations, and suggested follow-up questions.
List the messages in a Genie conversation with their answers and generated SQL, for example to replay a conversation history.
Get the rows returned by the SQL query Genie generated for a message. Available once the message is EXECUTING_QUERY or COMPLETED.
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.
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.
Rate a Genie answer as positive or negative, with an optional comment. Space authors use this feedback to improve the space's instructions.
Delete a message from a Genie conversation.
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.
Delete a Genie conversation you no longer need.
List the Genie spaces (Genie agents) you can access. Use this to find the space ID needed to ask Genie a question.
Get a Genie space's title, description, and SQL warehouse, optionally with its full configuration export (tables, instructions, sample questions).
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.
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.
Sim's Databricks integration adds 26 tools to the AI agents you build in Sim's visual workflow builder. Run SQL, manage jobs, and ask Genie agents on Databricks.
