Skip to main content
Last updated on

DESCRIBE POLICY

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 16.4 and above check marked yes Unity Catalog only

Shows the details of a policy as property-value pairs.

To run this statement, you must have the MANAGE privilege on the target securable.

Syntax​

{ DESC | DESCRIBE } POLICY policy_name ON { CATALOG catalog_name | SCHEMA schema_name | TABLE table_name }

Parameters​

  • policy_name

    The name of the policy to describe. If the policy does not exist on the securable, Databricks raises POLICY_NOT_FOUND.

  • catalog_name

    The name of the catalog on which the policy is defined.

  • schema_name

    The name of the schema on which the policy is defined.

  • table_name

    The name of the table on which the policy is defined.

Result​

The statement returns a formatted report.

Examples​

SQL
> DESCRIBE POLICY rf ON TABLE datagov.test.orders;

Name                    rf
On Securable Type       TABLE
On Securable            datagov.test.orders
To Principals           account users
For Securable Type      TABLE
Match Columns           hasTag('priority') AS u1
Policy Type             ROW_FILTER
  Function Name         datagov.test.hide_urgent_orders
  Using Columns         u1
Created By              user@databricks.com
Created At              2025-12-31 AD at 19:41:07 UTC
Updated By              user@databricks.com
Updated At              2026-01-01 AD at 22:01:17 UTC