MSCEWI3022

Siblings keyword removed from the order by clause because Snowflake does not support it.

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

Severity

Low

Description

SIBLINGS keyword was removed because is not supported in Snowflake.

Example Code

Input Code:

SELECT RANK() OVER (PARTITION BY USER_NAME ORDER SIBLINGS BY SALARY ASC NULLS FIRST, COMMISSION DESC NULLS LAST) FROM EMPLOYEES;

Output Code:

SELECT RANK() OVER (PARTITION BY USER_NAME ORDER BY SALARY ASC NULLS FIRST, COMMISSION DESC NULLS LAST) /*** MSC-WARNING - MSCEWI3022 - SIBLINGS KEYWORD REMOVED FROM ORDER BY CLAUSE BECAUSE SNOWFLAKE DOES NOT SUPPORT IT ***/ FROM PUBLIC.EMPLOYEES;

Recommendations

• No additional user actions are required.

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