Unity Catalog
Browse and manage Unity Catalog objects, permissions, volumes, and governance policies.
Example prompts
Section titled “Example prompts”“List all tables in my_catalog.my_schema”
“Grant SELECT on this table to the data-analysts group”
“Upload this CSV to /Volumes/catalog/schema/landing/data.csv”
manage_metric_views
Section titled “manage_metric_views”Description: Manage UC metric views (reusable business metrics). Requires DBR 17.2+.
Parameters:
| Parameter | Type | Required | Description |
|---|---|---|---|
action | str | Yes | — |
full_name | str | Yes | — |
source | str | No | — |
dimensions | List[Dict[str, str]] | No | — |
measures | List[Dict[str, str]] | No | — |
version | str | No | — |
comment | str | No | — |
filter_expr | str | No | — |
joins | List[Dict[str, Any]] | No | — |
materialization | Dict[str, Any] | No | — |
or_replace | bool | No | — |
query_measures | List[str] | No | — |
query_dimensions | List[str] | No | — |
where | str | No | — |
order_by | str | No | — |
limit | int | No | — |
principal | str | No | — |
privileges | List[str] | No | — |
warehouse_id | str | No | — |
manage_uc_connections
Section titled “manage_uc_connections”Description: Manage Lakehouse Federation foreign connections.
Parameters:
| Parameter | Type | Required | Description |
|---|---|---|---|
action | str | Yes | — |
name | str | No | — |
connection_type | str | No | — |
options | Dict[str, str] | No | — |
comment | str | No | — |
owner | str | No | — |
new_name | str | No | — |
connection_name | str | No | — |
catalog_name | str | No | — |
catalog_options | Dict[str, str] | No | — |
warehouse_id | str | No | — |
manage_uc_grants
Section titled “manage_uc_grants”Description: Manage UC permissions: grant/revoke/get/get_effective.
Parameters:
| Parameter | Type | Required | Description |
|---|---|---|---|
action | str | Yes | — |
securable_type | str | Yes | — |
full_name | str | Yes | — |
principal | str | No | — |
privileges | List[str] | No | — |
manage_uc_monitors
Section titled “manage_uc_monitors”Description: Manage Lakehouse quality monitors for data quality tracking.
Parameters:
| Parameter | Type | Required | Description |
|---|---|---|---|
action | str | Yes | — |
table_name | str | Yes | — |
output_schema_name | str | No | — |
schedule_cron | str | No | — |
schedule_timezone | str | No | — |
assets_dir | str | No | — |
manage_uc_objects
Section titled “manage_uc_objects”Description: Manage UC namespace objects: catalog/schema/volume/function.
Parameters:
| Parameter | Type | Required | Description |
|---|---|---|---|
object_type | str | Yes | — |
action | str | Yes | — |
name | str | No | — |
full_name | str | No | — |
catalog_name | str | No | — |
schema_name | str | No | — |
comment | str | No | — |
owner | str | No | — |
storage_root | str | No | — |
volume_type | str | No | — |
storage_location | str | No | — |
new_name | str | No | — |
properties | Dict[str, str] | No | — |
isolation_mode | str | No | — |
force | bool | No | — |
manage_uc_security_policies
Section titled “manage_uc_security_policies”Description: Manage row-level security and column masking.
Parameters:
| Parameter | Type | Required | Description |
|---|---|---|---|
action | str | Yes | — |
table_name | str | No | — |
column_name | str | No | — |
filter_function | str | No | — |
filter_columns | List[str] | No | — |
mask_function | str | No | — |
function_name | str | No | — |
function_body | str | No | — |
parameter_name | str | No | — |
parameter_type | str | No | — |
return_type | str | No | — |
function_comment | str | No | — |
warehouse_id | str | No | — |
manage_uc_sharing
Section titled “manage_uc_sharing”Description: Manage Delta Sharing: shares, recipients, and providers.
Parameters:
| Parameter | Type | Required | Description |
|---|---|---|---|
resource_type | str | Yes | — |
action | str | Yes | — |
name | str | No | — |
comment | str | No | — |
table_name | str | No | — |
shared_as | str | No | — |
partition_spec | str | No | — |
authentication_type | str | No | — |
sharing_id | str | No | — |
ip_access_list | List[str] | No | — |
share_name | str | No | — |
recipient_name | str | No | — |
include_shared_data | bool | No | — |
manage_uc_storage
Section titled “manage_uc_storage”Description: Manage storage credentials and external locations.
Parameters:
| Parameter | Type | Required | Description |
|---|---|---|---|
resource_type | str | Yes | — |
action | str | Yes | — |
name | str | No | — |
aws_iam_role_arn | str | No | — |
azure_access_connector_id | str | No | — |
url | str | No | — |
credential_name | str | No | — |
read_only | bool | No | — |
comment | str | No | — |
owner | str | No | — |
new_name | str | No | — |
force | bool | No | — |
manage_uc_tags
Section titled “manage_uc_tags”Description: Manage UC tags and comments.
Parameters:
| Parameter | Type | Required | Description |
|---|---|---|---|
action | str | Yes | — |
object_type | str | No | — |
full_name | str | No | — |
column_name | str | No | — |
tags | Dict[str, str] | No | — |
tag_names | List[str] | No | — |
comment_text | str | No | — |
catalog_filter | str | No | — |
tag_name_filter | str | No | — |
tag_value_filter | str | No | — |
table_name_filter | str | No | — |
limit | int | No | — |
warehouse_id | str | No | — |
manage_volume_files
Section titled “manage_volume_files”Description: Manage Unity Catalog Volume files: list, upload, download, delete, mkdir, get_info.
Parameters:
| Parameter | Type | Required | Description |
|---|---|---|---|
action | str | Yes | — |
volume_path | str | Yes | — |
local_path | Optional[str] | No | — |
local_destination | Optional[str] | No | — |
max_results | int | No | — |
recursive | bool | No | — |
max_workers | int | No | — |
overwrite | bool | No | — |