메뉴
Consult Snowflake CREATE MASKING POLICY parameter reference before generating any CREATE MASKING POLICY DDL.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Consult Snowflake CREATE AGGREGATION POLICY parameter reference before generating any CREATE AGGREGATION POLICY DDL.
Consult Snowflake CREATE ALERT parameter reference before generating any CREATE ALERT DDL.
Consult Snowflake CREATE API INTEGRATION parameter reference before generating any CREATE API INTEGRATION DDL.
Consult Snowflake CREATE APPLICATION PACKAGE parameter reference before generating any CREATE APPLICATION PACKAGE DDL.
Consult Snowflake CREATE AUTHENTICATION POLICY parameter reference before generating any CREATE AUTHENTICATION POLICY DDL.
Consult Snowflake CREATE COMPUTE POOL parameter reference before generating any CREATE COMPUTE POOL DDL.
| name | snowflake-create-masking-policy |
| description | Consult Snowflake CREATE MASKING POLICY parameter reference before generating any CREATE MASKING POLICY DDL. |
Before writing a CREATE MASKING POLICY statement:
references/parameters.md to review all available parameters and their defaults.CREATE OR REPLACE — always use CREATE MASKING POLICY IF NOT EXISTS.RETURNS must exactly match the data type of the first argument (<arg_name_to_mask>); cross-type transformations are not allowed.<body>) must be a valid SQL expression — use conditional functions (e.g. IFF, CASE) along with masking functions (e.g. SHA2, REGEXP_REPLACE) or return the column value unchanged.EXEMPT_OTHER_POLICIES = TRUE if the user explicitly needs this policy to bypass other row access or conditional masking policies — this setting cannot be changed once the policy is attached to a table or view.