This is a deprecated version of the SnowConvert documentation, please visit the official site .
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
;
