browse_unity_catalog
Browse Unity Catalog one level per call to list catalogs, schemas, tables, or columns and tags for a Databricks secret. Check whether data already exists before creating a pipeline.
Instructions
Browse what a Databricks Platform secret can already see in Unity Catalog, one level per call: no catalog lists catalogs; catalog lists its schemas; catalog + schema lists tables; adding table returns its columns (name, type, comment) and tags. Use it before creating a Databricks pipeline to check whether the data already exists. Discover the secret name with list_platform_secrets. Tables carrying the datris_pipeline tag were loaded by that Datris pipeline (query them with query_databricks and that pipeline). If tag lookups are not permitted for the secret, tagsAvailable is false and browsing still works. The SQL warehouse comes from the warehouse argument, else the secret's optional warehouse field, else an existing Databricks pipeline using the secret. A stopped SQL warehouse auto-starts on the first call, which can take 5-20 seconds (longer for classic warehouses). Read-only; catalog and schema listings are cached for 5 minutes.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"secret": "<secret>"
},
"name": "browse_unity_catalog"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | Table within `catalog`.`schema` to describe (optional; requires catalog and schema). | |
| schema | No | Schema within `catalog` to list tables of (optional; requires catalog). | |
| secret | Yes | Name of the Databricks Platform secret (from list_platform_secrets). | |
| catalog | No | Unity Catalog catalog to list schemas of (optional). | |
| warehouse | No | SQL warehouse ID to run the metadata queries on (optional; see description for the fallback order). |