Which SQL command can be used to see the CREATE definition of a masking policy?

The correct answer is C. GET_DDL. The GET_DDL() function returns the SQL CREATE statement (the DDL) for a named Snowflake object, including masking policies. For example: SELECT GET_DDL('MASKING_POLICY', 'MY_POLICY'). SHOW MASKING POLICIES (A) lists all masking policies with metadata but does not return the…

Data Governance

Question

Options

ASHOW MASKING POLICIES
BDESCRIBE MASKING POLICY
CGET_DDL
DLIST MASKING POLICIES

How the community answered

(52 responses)

A
2% (1)
B
6% (3)
C
88% (46)
D
4% (2)

Explanation

The GET_DDL() function returns the SQL CREATE statement (the DDL) for a named Snowflake object, including masking policies. For example: SELECT GET_DDL('MASKING_POLICY', 'MY_POLICY'). SHOW MASKING POLICIES (A) lists all masking policies with metadata but does not return the CREATE statement. DESCRIBE MASKING POLICY (B) shows the policy's columns and properties, not its full DDL. LIST MASKING POLICIES (D) is not a valid Snowflake command.

Topics

#GET_DDL function#Masking policies#DDL retrieval#Data governance

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice