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