Links

MSCEWI1089

Default Value Removed

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

  • No additional user actions are required.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.