MSCEWI1089

Default Value Removed

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

Severity

Low

Description

Snowflake procedures do not support default values for parameters. This warning message is added when a default value is removed from the procedure's parameter.

Code Example

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

Recommendations

• No additional user actions are required.

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