MSCEWI4009

The default value is not supported by Snowflake.

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

This EWI was removed and replaced by MSCEWI1089

Severity

Low

Description

This message is added when there was a default value in a parameter of a procedure. Since it is being removed in the translation, a warning is added.

Code Example

CREATE OR REPLACE PROCEDURE ProcTest (PARAM STRING, /*** MSC-WARNING - MSCEWI4009 - The default value 'Param2 Default' is not supported by Snowflake. ***/ PARAM2 STRING, PARAM3 STRING, /*** MSC-WARNING - MSCEWI4009 - The default value 'Param4 Default' is not supported by Snowflake. ***/ PARAM4 STRING)
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS

Recommendations

Last updated