SSC-EWI-OR0010
Partitions Clauses are Handled by Snowflake. It requires manual fix
Severity
Critical
Description
This warning appears when the PARTITION
and SUBPARTITION
clauses appear within a query. Snowflake handle partitions automatically
Example Code
Input Code:
Output Code:
Recommendations
Manual change is required to get equivalent functionality in Snowflake. A
WHERE
condition is needed to filter the rows for the specific partition. However, with this workaround, performance is affected.If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated