Databricks Workspace

What you can do

Connect this agent connector to let your agent:

• Schemata information schema — List all schemas within a catalog using INFORMATION_SCHEMA.SCHEMATA
• Constraints information schema table — List PRIMARY KEY and FOREIGN KEY constraints for tables in a schema using INFORMATION_SCHEMA.TABLE_CONSTRAINTS
• List unity catalog schemas, unity catalog catalogs, unity catalog tables — List all schemas within a Unity Catalog in the Databricks workspace
• Get sql statement result chunk, sql warehouse, sql statement — Fetch a specific result chunk for a paginated SQL statement result
• Tables information schema — List tables and views in a schema using INFORMATION_SCHEMA.TABLES
• Columns information schema — List columns for a table using INFORMATION_SCHEMA.COLUMNS

Authentication

This connector uses Service Principal (OAuth 2.0) authentication.

Tool list

databricksworkspace_cluster_get Get details of a specific Databricks cluster by cluster ID. 1 param ▾

Get details of a specific Databricks cluster by cluster ID.

Name Type Required Description

cluster_id string required The unique identifier of the cluster.

databricksworkspace_cluster_start Start a terminated Databricks cluster by cluster ID. 1 param ▾

Start a terminated Databricks cluster by cluster ID.

Name Type Required Description

cluster_id string required The unique identifier of the cluster to start.

databricksworkspace_cluster_terminate Terminate a Databricks cluster by cluster ID. The cluster will be deleted and all its associated resources released. 1 param ▾

Terminate a Databricks cluster by cluster ID. The cluster will be deleted and all its associated resources released.

Name Type Required Description

cluster_id string required The unique identifier of the cluster to terminate.

databricksworkspace_clusters_list List all clusters in the Databricks workspace. 0 params ▾

List all clusters in the Databricks workspace.

databricksworkspace_information_schema_columns List columns for a table using INFORMATION_SCHEMA.COLUMNS. Returns column name, data type, nullability, numeric precision/scale, max char length, and comment. 4 params ▾

List columns for a table using INFORMATION_SCHEMA.COLUMNS. Returns column name, data type, nullability, numeric precision/scale, max char length, and comment.

Name Type Required Description

catalog string required The catalog containing the table.

schema string required The schema containing the table.

table string required The table to list columns for.

warehouse_id string required The ID of the SQL warehouse to run the query on.

databricksworkspace_information_schema_schemata List all schemas within a catalog using INFORMATION_SCHEMA.SCHEMATA. Used for schema discovery during setup. 2 params ▾

List all schemas within a catalog using INFORMATION_SCHEMA.SCHEMATA. Used for schema discovery during setup.

Name Type Required Description

catalog string required The catalog to list schemas from.

warehouse_id string required The ID of the SQL warehouse to run the query on.

databricksworkspace_information_schema_table_constraints List PRIMARY KEY and FOREIGN KEY constraints for tables in a schema using INFORMATION_SCHEMA.TABLE_CONSTRAINTS. Used to auto-detect join keys. 3 params ▾

List PRIMARY KEY and FOREIGN KEY constraints for tables in a schema using INFORMATION_SCHEMA.TABLE_CONSTRAINTS. Used to auto-detect join keys.

Name Type Required Description

catalog string required The catalog containing the schema.

schema string required The schema to list constraints from.

warehouse_id string required The ID of the SQL warehouse to run the query on.

databricksworkspace_information_schema_tables List tables and views in a schema using INFORMATION_SCHEMA.TABLES. Returns table name, type (MANAGED, EXTERNAL, VIEW, etc.), and comment for schema discovery. 3 params ▾

List tables and views in a schema using INFORMATION_SCHEMA.TABLES. Returns table name, type (MANAGED, EXTERNAL, VIEW, etc.), and comment for schema discovery.

Name Type Required Description

catalog string required The catalog to query INFORMATION_SCHEMA from.

schema string required The schema to list tables from.

warehouse_id string required The ID of the SQL warehouse to run the query on.

databricksworkspace_job_get Get details of a specific Databricks job by job ID. 1 param ▾

Get details of a specific Databricks job by job ID.

Name Type Required Description

job_id integer required The unique identifier of the job.

databricksworkspace_job_run_now Trigger an immediate run of a Databricks job by job ID. 1 param ▾

Trigger an immediate run of a Databricks job by job ID.

Name Type Required Description

job_id integer required The unique identifier of the job to run.

databricksworkspace_job_runs_list List all job runs in the Databricks workspace, optionally filtered by job ID. 3 params ▾

List all job runs in the Databricks workspace, optionally filtered by job ID.

Name Type Required Description

job_id integer optional Filter runs by a specific job ID. If omitted, returns runs for all jobs.

limit integer optional The number of runs to return. Defaults to 20. Maximum is 1000.

offset integer optional The offset of the first run to return.

databricksworkspace_jobs_list List all jobs in the Databricks workspace. 2 params ▾

List all jobs in the Databricks workspace.

Name Type Required Description

limit integer optional The number of jobs to return. Defaults to 20. Maximum is 100.

offset integer optional The offset of the first job to return.

databricksworkspace_scim_me_get Retrieve information about the currently authenticated service principal in the Databricks workspace. 0 params ▾

Retrieve information about the currently authenticated service principal in the Databricks workspace.

databricksworkspace_scim_users_list List all users in the Databricks workspace using the SCIM v2 API. 3 params ▾

List all users in the Databricks workspace using the SCIM v2 API.

Name Type Required Description

count integer optional Maximum number of results to return per page.

filter string optional SCIM filter expression to narrow results (e.g. userName eq "user@example.com").

startIndex integer optional 1-based index of the first result to return. Used for pagination.

databricksworkspace_secrets_scopes_list List all secret scopes available in the Databricks workspace. 0 params ▾

List all secret scopes available in the Databricks workspace.

databricksworkspace_sql_statement_cancel Cancel a running SQL statement by its statement ID. 1 param ▾

Cancel a running SQL statement by its statement ID.

Name Type Required Description

statement_id string required The ID of the SQL statement to cancel.

databricksworkspace_sql_statement_execute Execute a SQL statement on a Databricks SQL warehouse and return the results. 4 params ▾

Execute a SQL statement on a Databricks SQL warehouse and return the results.

Name Type Required Description

statement string required The SQL statement to execute.

warehouse_id string required The ID of the SQL warehouse to execute the statement on.

catalog string optional The catalog to use for the statement execution.

schema string optional The schema to use for the statement execution.

databricksworkspace_sql_statement_get Get the status and results of a previously executed SQL statement by its statement ID. 1 param ▾

Get the status and results of a previously executed SQL statement by its statement ID.

Name Type Required Description

statement_id string required The ID of the SQL statement to retrieve.

databricksworkspace_sql_statement_result_chunk_get Fetch a specific result chunk for a paginated SQL statement result. Use when a statement result has multiple chunks (large result sets). 2 params ▾

Fetch a specific result chunk for a paginated SQL statement result. Use when a statement result has multiple chunks (large result sets).

Name Type Required Description

chunk_index integer required The index of the result chunk to fetch (0-based).

statement_id string required The ID of the SQL statement.

databricksworkspace_sql_warehouse_get Get details of a specific Databricks SQL warehouse by its ID. 1 param ▾

Get details of a specific Databricks SQL warehouse by its ID.

Name Type Required Description

warehouse_id string required The ID of the SQL warehouse to retrieve.

databricksworkspace_sql_warehouse_start Start a stopped Databricks SQL warehouse by its ID. 1 param ▾

Start a stopped Databricks SQL warehouse by its ID.

Name Type Required Description

warehouse_id string required The ID of the SQL warehouse to start.

databricksworkspace_sql_warehouse_stop Stop a running Databricks SQL warehouse by its ID. 1 param ▾

Stop a running Databricks SQL warehouse by its ID.

Name Type Required Description

warehouse_id string required The ID of the SQL warehouse to stop.

databricksworkspace_sql_warehouses_list List all SQL warehouses available in the Databricks workspace. 0 params ▾

List all SQL warehouses available in the Databricks workspace.

databricksworkspace_unity_catalog_catalogs_list List all Unity Catalogs accessible to the service principal in the Databricks workspace. 0 params ▾

List all Unity Catalogs accessible to the service principal in the Databricks workspace.

databricksworkspace_unity_catalog_schemas_list List all schemas within a Unity Catalog in the Databricks workspace. 1 param ▾

List all schemas within a Unity Catalog in the Databricks workspace.

Name Type Required Description

catalog_name string required The name of the catalog to list schemas from.

databricksworkspace_unity_catalog_tables_list List all tables and views within a schema in a Unity Catalog in the Databricks workspace. 2 params ▾

List all tables and views within a schema in a Unity Catalog in the Databricks workspace.

Name Type Required Description

catalog_name string required The name of the catalog containing the schema.

schema_name string required The name of the schema to list tables from.