The 6.7 release of Snowflake platform will remove recursion limit for queries. Snowflake plans to release the change in March (no exact date).
For more information follow this post on Keboola Community or check out the official Snowflake pending behavior change log.