SSC-EWI-TS0053
Multiple selects in if body were partially transformed.
Severity
High
Some parts of the output code are omitted for clarity reasons.
Description
This EWI is added to one or more resulting CTEs of a UDF transformation that generates a Snowflake function, when the IF statement that was the source for such CTE only contained variable assignments using the SELECT @local_variable
syntax.
Even though this EWI's severity is set to high, the basic scenarios like the one from the code example are proven to work as intended, however depending on the complexity of each individual SELECT
statement, and the overall amount of statements inside the IF
's BEGIN ... END
block, the functional equivalence of the result compared to the input code cannot be guaranteed.
Code Example
Input Code:
Output Code:
Recommendations
If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated