rocketkind
Databases

Databricks

Databricks is a lakehouse platform — Delta tables governed by Unity Catalog, SQL warehouses that query them, and Lakeflow jobs that transform them.

Authentication

  • Personal access token

Actions

Generic API request. Call any Databricks workspace API endpoint on this connection, for the case where no shipped action covers it yet. The connection supplies the base URL, the authentication and the egress route, so only the path, query and body are yours to fill.

  • Cancel job runDestructiveCancel a job run or task run.
  • Cancel SQL statementDestructiveAsk Databricks to cancel a running statement.
  • Execute SQL statementDestructiveRun one SQL statement on a SQL warehouse and get its status and, when it finishes within waittimeout, the first chunk of rows.
  • Get clusterRead one cluster's configuration and current state, including why it terminated.
  • Get job runRead one job run's state, timings, task runs and resolved parameters.
  • Get SQL result chunkFetch one chunk of a finished statement's result by index, for results too large for the first chunk.
  • Get SQL statementRead the current status of a statement started with databricks:executestatement and, once body.status.state is SUCCEEDED, its manifest and first chunk of rows.
  • Get SQL warehouseRead one SQL warehouse's configuration and current state (STARTING, RUNNING, STOPPED, …).
  • List catalogsList the Unity Catalog catalogs the caller can see in the workspace's metastore.
  • List clustersList the workspace's pinned and active all-purpose and job clusters plus those terminated in the last 30 days, with id, name, state and runtime.
  • List job runsList job runs, most recent first, optionally for one job, only active or only completed runs, or a start-time window.
  • List jobsList the Lakeflow jobs in the workspace, newest first, with each job's jobid, name and creator.
  • List query historyList recent queries run on SQL warehouses and serverless compute, newest first, with their status, SQL text, warehouse, user and timings.
  • List schemasList the schemas in one Unity Catalog catalog that the caller owns or holds USESCHEMA on.
  • List SQL warehousesList the SQL warehouses in the workspace with their id, name, state, size and type.
  • List tablesList the tables and views in one Unity Catalog schema, with type, format, storage location and columns.
  • Run job nowDestructiveTrigger an immediate run of an existing Databricks job, optionally overriding its job parameters.
  • Start SQL warehouseDestructiveStart a stopped SQL warehouse so statements can run on it without waiting for an autostart.

Product names, logos and brands are the property of their respective owners and are used here for identification only. Their use does not imply endorsement by, or affiliation with, those owners.