SSC-EWI-OR0110
For Update Clause is not supported in Snowflake
Some parts in the output code are omitted for clarity reasons.
Severity
High
Description
There is no equivalent for FOR UPDATE
clause in Snow Scripting so an EWI is added and the clause is commented out
Example Code
Input Code:
Output Code:
Related EWIS
SSC-EWI-0036: Data type converted to another data type.
SSC-EWI-0058: Functionality is not currently supported by Snowflake Scripting.
SSC-EWI-0R0036: Types resolution issues, the arithmetic operation may not behave correctly between string and date.
SSC-EWI-OR0136: Current of clause is not supported in Snowflake.
SSC-PRF-0004: This statement has usages of cursor for loop.
Recommendations
Handle the column update in the
UPDATE/DELETE
query for more details check SSC-EWI-0075.If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated