MSCEWI3023

DENSE_RANK aggregate function syntax is not supported by Snowflake.

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

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 [email protected]