Support for nested WITH statements

TL;DR: nested WITH statements are supported in all modern data warehouses, lakehouses, and database engines except for Fabric & T-SQL products. This makes the usage of SQL templating engines unneces...

data warehouse

xiaoyuli

Microsoft Employee

2 years ago

Thanks for your feedback. We are working on adding the support of nested CTE to Fabric Warehousing.

Recent ideas

Fabric Gateway Connection Lineage View.
Fabric Gateway Connection Lineage View. The Lineage view would provide administrators with visibility to all dependencies on a connection. Identifying all impacted resources in order to consolidat...
Azurenaut
Frequent Visitor
1 hour ago
New
Views
0likes
Comments
Copy results as markdown from data grid
When copying results from a query on the SQL Endpoint or Data Warehouse I often have to convert from the tab delimited table to markdown for sharing the results via services like teams or github. It...
Tom_Fosterbi
Regular Visitor
1 hour ago
New
Views
2likes
Comment
File level commit - Need the ability to edit the commit description
I tried the recently announce file level commit for Fabric items. One notable issue I have with the feature (testing this with a Fabric warehouse, I'm assuming this would hold true for other items): ...
DataBard
Most Valuable Professional
2 hours ago
New
Views
0likes
Comment
new monitoring hub needs refresh pause
I like the new monitoring hub, but can you add a functionality for manual refreshes? each time I scroll to step in the pipeline it refreshes and I can't see what's going on!
bbastian1
New Member
2 hours ago
New
Views
1like
Comments
Power BI Report Subscription - Restore Line Break Formatting
After the recent update, report subscription content is being generated as a single paragraph with all information combined into one block of text. This makes the output difficult to read. Please re...
dataguy213
New Member
2 hours ago
New
Views
1like
Comments

Support for nested WITH statements

Fabric Gateway Connection Lineage View.

Copy results as markdown from data grid

File level commit - Need the ability to edit the commit description

new monitoring hub needs refresh pause

Power BI Report Subscription - Restore Line Break Formatting