Databricks

Analytics & dataCredentials form

Run SQL on Databricks SQL warehouses, browse Unity Catalog, and list and run jobs and clusters in a Databricks workspace.

15 actions

ActionEffectData handledScope
databricks_execute_statementRuns a SQL statement on a SQL warehouse and waits up to waitTimeout (default 30s) for the resultwritePersonal data
databricks_get_statementGets a statement's state and, once it succeeded, its schema and first chunk of rowsreadPersonal data
databricks_get_statement_result_chunkGets one further chunk of rows of a finished statement, for results larger than the first chunk; next_chunk_index says which to ask forreadPersonal data
databricks_cancel_statementCancels a running SQL statementwriteGeneral
databricks_list_warehousesLists SQL warehouses with their ids, sizes and statesreadGeneral
databricks_list_catalogsLists the Unity Catalog catalogs the user can seereadGeneral
databricks_list_schemasLists the schemas of a Unity Catalog catalogreadGeneral
databricks_list_tablesLists the tables and views of a Unity Catalog schema with their types, formats and ownersreadGeneral
databricks_get_tableGets a Unity Catalog table's columns with types and comments, its storage format, location, owner and propertiesreadGeneral
databricks_list_jobsLists jobs with their ids, names, schedules and creators, optionally filtered by exact namereadGeneral
databricks_run_jobTriggers a run of a job now, optionally with job parameters, and returns the run idwriteGeneral
databricks_list_job_runsLists job runs, newest first, with their states, start times and durations, optionally for one job or only active runsreadGeneral
databricks_get_job_runGets one job run with its state, result, task runs, timings and error messagereadGeneral
databricks_list_clustersLists all-purpose and job clusters with their ids, states, node types and Spark versionsreadGeneral
databricks_start_clusterStarts a terminated clusterwriteGeneral