SSC-FDM-OR0013

The cycle clause was is not supported in Snowflake.

This FDM is deprecated, please refer to SSC-EWI-OR0039 documentation.

Description

This message is shown when SnowConvert finds a query with a CYCLE clause. Which is not supported in Snowflake, so it is commented out from the code.

This clause marks when there is a recursion.

For more details see the documentation about the clause functionality.

Example Code

Connect By

Input Code:

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:

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
--** SSC-FDM-OR0013 - CYCLE 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 [email protected]