SSC-EWI-OR0039
The nocycle clause was is not supported in Snowflake.
Severity
Low
Description
This message is shown when SnowConvert finds a query with a NOCYCLE clause, which is not supported in Snowflake.
This clause marks when there is a recursion.
For more details see the documentation about the clause functionality.
Example Code
Connect By
Input Code:
Output Code:
Recommendations
If there are cycles in the data hierarchy, you can review this article to deal with them.
If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated