MSCEWI3056

Snowflake does not support the versioning of objects. Developers should consider alternate approaches for code versioning.

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

Severity

Low

Description

Snowflake doesn't support the versioning of objects. The modifier EDITINONABLE or NONEDITIONABLE is removed in the converted code and a warning is added.

Example Code

Input Code:

CREATE OR REPLACE EDITIONABLE PROCEDURE FUN1 (n number)is
l_result number;
begin
    /* Procedure content */
end;

Output Code:

/*** MSC-WARNING - MSCEWI3056 - SNOWFLAKE DOESN'T SUPPORT VERSIONING OF OBJECTS. DEVELOPERS SHOULD CONSIDER ALTERNATE APPROACHES FOR CODE VERSIONING. ***/

CREATE OR REPLACE PROCEDURE PUBLIC.FUN1 (n FLOAT)
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
   /* Procedure content */
$$;

Recommendations

• The user should consider alternate approaches for code versioning.

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