Comment on page

MSCEWI4066

Routine option not supported in Snowflake

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]​

MSCEWI4065

MSCEWI4067

Last modified 22d ago