This is a deprecated version of the SnowConvert documentation, please visit the official site .
Severity
Medium
Description
Snowflake does not have an equivalent for option NOCYCLE of the Oracle Connect By clause.
Example Code
Input Code:
SELECT UNIQUE A.* FROM TABLE1 A WHERE A.X = A.C CONNECT BY NOCYCLE A.C = 0 START WITH A.B = 1 HAVING X = 1 GROUP BY A.C;
Output Code:
SELECT DISTINCT A.* FROM PUBLIC.TABLITA A
WHERE A.X = A.C
GROUP BY A.C
HAVING X = 1
/*** MSC-ERROR - MSCEWI3063 - NOCYCLE property in a hierarchical clause is not supported in Snowflake ***/
CONNECT BY A.C = 0 START WITH A.B = 1;