MSC-PG0006

Raise notice translated to user-defined stored procedure.

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

Severity

Low

Description

It indicates that a RAISE NOTICE statement has been transformed to a Procedure Call, since the RAISE statment is not supported in Snowflake.

Code Example

Input Code:

PostgreSQL

RAISE NOTICE '% - Current schema is %',v_var1, v_var2;

Output Code:

Snowflake

SC_RAISE_MESSAGE := STRING_FORMAT_UDF('% - Current schema is %', array_construct(:v_var1, :v_var2));
--** MSC-WARNING - MSC-PG0006 - RAISE NOTICE TRANSLATED TO USER-DEFINED STORED PROCEDURE **
CALL RAISE_MESSAGE_UDF('NOTICE', :SC_RAISE_MESSAGE);

Recommendations

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