SSC-EWI-OR0010
Partitions Clauses are Handled by Snowflake. It requires manual fix
Some parts of the output code are omitted for clarity reasons.
Severity
Critical
Description
This warning appears when the PARTITION
and SUBPARTITION
clauses appear within a query. Snowflake handle partitions automatically
Example Code
Input Code:
IN -> Oracle_01.sql
Output Code:
OUT -> Oracle_01.sql
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