Skip to main content

DESC MASKING POLICY

Introduced or updated: v1.2.45
ENTERPRISE EDITION FEATURE
MASKING POLICY is an Enterprise Edition feature. Contact Databend Support for a license.

Displays detailed information about a specific masking policy in Databend.

Syntax

DESC MASKING POLICY <policy_name>

Examples

CREATE MASKING POLICY email_mask
AS
(val string)
RETURNS string ->
CASE
WHEN current_role() IN ('MANAGERS') THEN
val
ELSE
'*********'
END
COMMENT = 'hide_email';

DESC MASKING POLICY email_mask;

Name |Value |
-----------+---------------------------------------------------------------------+
Name |email_mask |
Created On |2023-08-09 02:29:16.177898 UTC |
Signature |(val STRING) |
Return Type|STRING |
Body |CASE WHEN current_role() IN('MANAGERS') THEN VAL ELSE '*********' END|
Comment |hide_email |
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today