Exception system variables are not supported in Snowflake.
Description
This EWI is added when a statement references exception variables in BigQuery because they are not supported in Snowflake, and the content of these variables is quite different from the exception variables allowed in Snowflake. For more information please refer to Handling Exceptions in Snowflake.
Code Example
Input Code:
IN -> BigQuery_01.sql
CREATE OR REPLACE PROCEDURE test.proc1()
BEGIN
SELECT 1/0;
EXCEPTION WHEN ERROR THEN
SELECT
@@error.message as message,
@@error.stack_trace as stack_trace,
@@error.statement_text as statement_text,
@@error.formatted_stack_trace as formatted_stack_trace;
END;