MSCEWI5001

WITH ROW ACCESS POLICY CLAUSE DOES NOT SUPPORT MULTIPLE DECLARATION

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This message is shown whenever SnowConvert detects multiple security label column options inside the same CREATE TABLE clause, the security label is translated to a row access policy clause and Snowflake does not support multiple row access policy declarations. Therefore, if more than one security labels are found they will be commented out with this EWI.

Code example

Input code:

CREATE TABLE T1
(
COL1 VARCHAR(10) COLUMN SECURED WITH securityLabel1,
COL2 VARCHAR(10) COLUMN SECURED WITH securityLabel2
);

Output code:

CREATE TABLE T1
(
COL1 VARCHAR(10),
COL2 VARCHAR(10)
) WITH ROW ACCESS POLICY securityLabel1 ON (COL1)
-- ** MSC-WARNING - MSCEWI5001 - WITH ROW ACCESS POLICY CLAUSE DOES NOT SUPPORT MULTIPLE DECLARATION IN SNOWFLAKE **
--                                                  WITH ROW ACCESS POLICY securityLabel2 ON (COL2);

Recommendations

• Review your code and ensure that only one security label is inside the CREATE TABLE clause

• If you need more support, you can email us at [email protected]