Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Snowflake Table DDL support of WITH MASKING POLICY column definition #201

Copy link
Copy link
@dmaresma

Description

@dmaresma
Issue body actions

Is your feature request related to a problem? Please describe.
I would like to improve the CREATE TABLE statement of Snowflake ddl to support the Column WITH MASKING POLICY.

Describe the solution you'd like
CREATE OR REPLACE TABLE schemaName.TableAddresses (
AddressID NUMBER(38,0) NOT NULL,
Address1 VARCHAR(100) WITH MASKING POLICY DBName.MASKING_POLICY_LIBRARY.MASK_STRING WITH TAG (DBName.MASKING_POLICY_LIBRARY.PROJECT_POLICY_MASK='mask_object')
);
Supported by DDLParser.run() functions

Describe alternatives you've considered
add MASKING POLICY and TAG members same as Comment, Nullable or Default properties

https://docs.snowflake.com/en/sql-reference/sql/create-table

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

    Morty Proxy This is a proxified and sanitized view of the page, visit original site.