MSC-PG0013

Unsupported Raise Exception.

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

Severity

Medium

Description

The Raise Exception outside of an Exception Block is not supported because it requires creating a custom exception based on dynamic data, which is not suppored in Snowflake. Snowflake only supports creating new exceptions with a literal message.

Code Example

Input Code:

PostgreSQL

RAISE EXCEPTION '% - 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-ERROR - MSC-PG0013 - UNSUPPORTED RAISE EXCEPTION, CREATING A DYNAMIC CUSTOM EXCEPTION IS NOT SUPPORTED IN SNOWFLAKE. **
CALL RAISE_MESSAGE_UDF('EXCEPTION', :SC_RAISE_MESSAGE);

Recommendations

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