MSCEWI4066

Routine option not supported in Snowflake

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

Severity

Low

Description

This EWI is added when some of the following routine options is used

• WITH ENCRYPTION

• WITH RECOMPILE

• WITH EXECUTE AS 'specific_username'

• FOR REPLICATION

Input Code:

CREATE OR ALTER PROCEDURE GetVacationHours
   @Param1 INT,  
   @Param2 INT,
   @Param3 INT,
   @Param4 INT
WITH ENCRYPTION, RECOMPILE, EXECUTE AS 'user_name'
FOR REPLICATION
AS
BEGIN  
   SELECT * FROM Table1;
END

Output Code:

CREATE OR REPLACE PROCEDURE PUBLIC.GetVacationHours (PARAM1 FLOAT, PARAM2 FLOAT, PARAM3 FLOAT, PARAM4 FLOAT)
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
/*** MSC-WARNING - MSCEWI4066 - ROUTINE OPTION 'ENCRYPION OPTION' IS NOT SUPPORTED IN SNOWFLAKE ***/
/*** MSC-WARNING - MSCEWI4066 - ROUTINE OPTION 'RECOMPILE OPTION' IS NOT SUPPORTED IN SNOWFLAKE ***/
/*** MSC-WARNING - MSCEWI4066 - ROUTINE OPTION 'EXECUTE AS USER_NAME' IS NOT SUPPORTED IN SNOWFLAKE ***/
/*** MSC-WARNING - MSCEWI4066 - ROUTINE OPTION 'FOR REPLICATION' IS NOT SUPPORTED IN SNOWFLAKE ***/
AS
$$
   BEGIN
      SELECT
         *
      FROM
         PUBLIC.Table1;
   END;
$$;

Recommendations

• No additional user actions are required.

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