Comment on page
MSCEWI4066
Routine option not supported in Snowflake
Low
This EWI is added when some of the following routine options is used
- WITH ENCRYPTION
- WITH RECOMPILE
- WITH EXECUTE AS 'specific_username'
- FOR REPLICATION
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
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;
$$;
- No additional user actions are required.
Last modified 22d ago