MSCEWI3056

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

triangle-exclamation

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

Last updated