SnowflakeDocumentation Home

MSCEWI3065

The NOCYCLE property in a hierarchical clause is not supported in Snowflake.

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

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;

Recommendations

PreviousMSCEWI3064NextMSCEWI3066

Last updated