How implementing an hierarchy without using a recursive CTE

[pmscorca]

Hi,

I've noticed that the warehouse T-SQL doesn't support the recursive ctes and this is a pity!

Now, how could I implement an hierarchy in T-SQL without a such useful and comfortable feature, please? Thanks

In the future, will fabric support this feature?

[rubayatyasmin]

Hi @pmscorca 

Did you try the closure table? sql - How can I create a closure table using data from an adjacency list? - Stack Overflow

[lbendlin]

Does it have to be in T-SQL?  Could you use the DAX PATH functions?

[pmscorca]

Hi, I need to have an hierarchy at warehouse level and not at semantic model level.

However, the recursive CTEs are also useful for other purposes.

Update: I've created this idea Adding support for recursive CTEs in a warehouse ; please vote it, thanks.

[v-menakakota]

 Hi @pmscorca ,

Thanks for reaching out to the Microsoft fabric community forum.

You’ve taken the right step by raising and sharing the idea to add recursive CTE support. That’s currently the best path forward, as this is a platform capability gap rather than a configuration issue. Encouraging others to vote on it will help increase visibility and priority.

Best Regards, 
Community Support Team