MSCEWI3023

DENSE_RANK aggregate function syntax is not supported by Snowflake.

Severity

High

Description

DENSE_RANK function is not currently supported.

Example Code

Input Code:

SELECT DENSE_RANK(12000) WITHIN GROUP (ORDER BY salary DESC NULLS FIRST) FROM employees;

Output Code:

SELECT
/*** MSC-ERROR - MSCEWI3023 - DENSE_RANK AGGREGATE FUNCTION SYNTAX IS NOT SUPPORTED BY SNOWFLAKE. ***/
DENSE_RANK_STUB('DENSE_RANK(12000) WITHIN GROUP (ORDER BY salary DESC NULLS FIRST)')
FROM PUBLIC.employees;

Recommendations

  • The function is converted to a user defined function(stub) so you can modify it to emulate the functionality.

  • If you need more support, you can email us at snowconvert-support@snowflake.com