MSCEWI2045

Warning View With Check Option Not Supported.

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

Severity

Low

Description

View With Option Not Supported in Snowflake.

Example Code

Input Code:

REPLACE VIEW VIEWWITHOPTIONTEST AS
LOCKING ROW FOR ACCESS
SELECT 
    *        
FROM SOMETABLE
WHERE app_id = 'SUPPL

Output Code:

CREATE OR REPLACE VIEW DATAWAREHOUSE.PUBLIC.VIEWWITHOPTIONTEST
AS
SELECT
*
FROM DATAWAREHOUSE.PUBLIC.SOMETABLE
WHERE app_id = 'SUPPLIER'
-- ** MSC-WARNING - MSCEWI2045 - VIEW WITH OPTION NOT SUPPORTED IN SNOWFLAKE **
--WITH CHECK OPTION
                 ;

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [e-mail]