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 unnecessarily complex.
Fabric supports regular WITH statements like the following:
...
STATUS
DETAILS
Planned
Give workspace access to service principals
Currently, you can only give access to workspaces to individual Azure AD users.
I want to give service principals access to my workspaces so that I can authenticate to OneLake using a service principal. This lets me connect to OneLake from applications, scripts, and more witho...
STATUS
DETAILS
Under Review