Share via

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, Azure 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

> 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
  • Last updated on