Links

MSCEWI2045

Warning View With Check Option Not Supported.

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.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.