MSCEWI1072

Window frame unit was changed to Rows

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This warning is added when an unsupported Window Frame Unit was changed into Rows, leading to output differences. One example of this is the GROUPS unit, which is not supported by Snowflake.

Please note that this message is also used in cases where a Window Frame Unit is partially unsupported leading to it being changed, like the RANGE unit.

Example Code

Oracle:

SELECT
SUM(C_BIRTH_DAY)
OVER (ORDER BY C_BIRTH_COUNTRY
    RANGE BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING) AS MAX1
FROM WINDOW_TABLE;

Snowflake:

SELECT
SUM(C_BIRTH_DAY)
OVER (ORDER BY C_BIRTH_COUNTRY
 ROWS /*** MSC-WARNING - MSCEWI1072 - WINDOW FRAME UNIT 'RANGE' WAS CHANGED TO ROWS ***/ BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING) AS MAX1
FROM PUBLIC.WINDOW_TABLE;

Recommendations

• Ensure deterministic ordering for rows to ensure deterministic outputs when running in Snowflake.

• If you need more support, you can email us at [email protected]