I have several tables in Postgres that we are migrating to Snowflake. Some of these table are hierarchical (a foreign key point to the same table), normally to query this data I use CTE tables and/or recursive SQL statements.
As far as I can tell Snowflake does not support these operations. Are there any other queries that can be made to mimic this or work around this?
"Currently, Snowflake does not fully support common table expressions (CTE) in DDL operations."
Snowflake documentation: https://docs.snowflake.net/manuals/sql-reference/constructs/with.html