Conditional Compilation

Translation reference to convert Oracle Conditional Compilation statement to Snowflake Scripting

Description

Provides conditional compilation based on the truth value of a condition.

For more information regarding Oracle Conditional Compilation IF, check here.

$IF conditional_expression $THEN
     statement
     [ statement ]... 
[ $ELSIF conditional_expression $THEN
     statement
     [ statement ]... ]...
[ $ELSE   
     statement
     [ statement ]... ]
$END;

Sample Source Patterns

Possible IF variations

Oracle

Code 1

CREATE OR REPLACE PROCEDURE PROCEDURE_DEMO ()
   AS
   BEGIN
      SELECT 2 FROM DUAL;
      $IF $$debug_flag
      $THEN
         SELECT 1 FROM DUAL;
      $END
   END PROCEDURE_DEMO;

Snowflake Scripting

Query 1

CREATE OR REPLACE PROCEDURE PROCEDURE_DEMO ()
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
   BEGIN
      SELECT 2 FROM DUAL;
-- ** MSC-ERROR - MSCEWI1037 - TRANSLATION FOR DOLLAR IF STATEMENT IS PLANNED TO BE DELIVERED IN THE FUTURE **
--      $IF $$debug_flag
--      $THEN
--         SELECT 1 FROM DUAL;
--      $END
   END;
$$;

Known issues

1. Transformation of Conditional Compilation is not currently supported.

Related EWIs

MSCEWO1037 Translation planned for the future.