Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedFabric Ideas just got better! New features, better search, and direct team engagement. Learn more
Support for temp tables was introduced recently in Fabric warehouses. For workloads/applications that are migrated from Azure Synapse SQL dedicated pools, this is a very important feature. While I understand that Distributed temp tables are ideal going forward considering new architecture of warehouse (decoupled storage/compute). Existing applications (that support Azure synapse SQL pools) still use syntax that for Non-distributed #temp Table in application generated queries and SQL statements.
So here is what I ask-
there should be configuration/setting for a warehouse to have default mechanism for temp tables to be distributed temp tables. Once its enabled, users/apps don't have to add clause below explicitly while creating temp tables
WITH (DISTRIBUTION=ROUND_ROBIN)
This will ensure that Insert into #temp table statements are supported (as they are only supported for distributed temp tables but not for non-distributed temp tables).
@TwinkleCyril Tagging you here since you originally posted blog on this feature.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.