SSC-EWI-OR0039

The nocycle clause was is not supported in Snowflake.

Some parts in the output code are omitted for clarity reasons.

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:

IN -> Oracle_01.sql

CREATE OR REPLACE FORCE NONEDITIONABLE VIEW VIEW01 AS
SELECT
      UNIQUE A.*
FROM
      TABLITA 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:

OUT -> Oracle_01.sql

CREATE OR REPLACE VIEW VIEW01
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"oracle"}}'
AS
SELECT DISTINCT
      A.*
FROM
      TABLITA A
WHERE
      A.X = A.C
GROUP BY
      A.C
HAVING
      X = 1
!!!RESOLVE EWI!!! /*** SSC-EWI-OR0039 - NOCYCLE CLAUSE IS NOT SUPPORTED IN SNOWFLAKE ***/!!!
CONNECT BY
      A.C = 0 START WITH A.B = 1;

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 [e-mail].

• Please review the following link for manual workaround: https://community.snowflake.com/s/article/NOCYCLE-workaround