Which technique uses a WITH clause that references itself to query hierarchical data?

• A. Connect By
• B. Recursive CTEs
• C. Recursion
• D. Connect With

Answer: (B)

Recursive common table expressions use a WITH clause that references itself to walk a hierarchy. You define an anchor query to seed the results, then a recursive member that references the CTE name to fetch child rows, feeding those back into the same CTE until no new rows appear or a depth limit is reached. This pattern lets you efficiently traverse trees or hierarchies, such as organizational structures or bill of materials, directly within Snowflake using WITH RECURSIVE. Other options describe different hierarchical query approaches (like Oracle’s Connect By) or are simply general terms, and they don’t involve a WITH clause that self-references to iteratively build the result set.