Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.

Adding support for recursive CTEs in a warehouse

Hi,

I've noticed that T-SQL language of a warehouse doesn't support the recursive CTEs. It'a real pity!

A such feature is more useful and comfortable one in several scenarios, f.e. to navigate an hierarchy.

I hope it will be implemented as soon as possible. Thanks

Status: New
Comments
sanjeevkamboj13
New Member
i agree if we think from referential integrity constraint . but we can use utility functions to verify the data before inserting . defiantly not possible for any manual insertion
phil_mad
Frequent Visitor
Recursive SQL for wh and lh endpoint is definitely a must have for a serious platform. The sql server object supports this but you can't build directly a semantic model on it. At least i haven't found this yet.
hedeencharles
Advocate I
This is a must have feature for us. We understand it was not available in Synapse but would like to see it in Fabric Data Warehouse. Any update MS team?