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
SELECT * FROM table1 PARTITION(col1);

Output Code:

OUT -> Oracle_01.sql
SELECT * FROM
table1
        !!!RESOLVE EWI!!! /*** SSC-EWI-OR0010 - PARTITIONS CLAUSES ARE HANDLED BY SNOWFLAKE. IT REQUIRES MANUAL FIX ***/!!!
        PARTITION(col1);

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