Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

Visual recursive queries using CTEs

Most SQL databases support Common Table Expression style recursion using the WITH RECURSIVE syntax. This allows subqueries to reference their own names. It would be helpful for visual recipes to be able to perform hierarchical or recursive queries to make this type of data somewhat more manageable.