SSC-FDM-OR0045

Partitions Clauses are Handled by Snowflake

Some parts of the output code are omitted for clarity reasons.

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 TABLITA PARTITION(col1);

Output Code:

OUT -> Oracle_01.sql
SELECT * FROM
TABLITA
--        --** SSC-FDM-OR0045 - PARTITIONS CLAUSES ARE HANDLE BY SNOWFLAKE **
--        PARTITION(col1)
                             ;

Recommendations

Last updated