Forum Discussion

Community Champion

2 years ago

Solved

CTAS and temp db

I am having issues when I am trying to use CTAS in a tempdb. This works // no ctas IF OBJECT_ID('tempdb..#test', 'U') IS NOT NULL DROP TABLE #test; -- Create table CREATE TABLE #test ( ...

data warehouse

AndyDDC
2 years ago
Hi smpa01 as per MS documentation, temp tables are not officially supported (even though they are present...). MS are looking into the usage scenarios of temp tables currently.

https://learn.microsoft.com/en-us/fabric/data-warehouse/tsql-surface-area

I have a blog which covers what does and doesn't work with the unsupported temp tables in Fabric.

https://www.serverlesssql.com/temp-tables-in-fabric-warehouses/

AndyDDC

Most Valuable Professional

2 years ago

Hi smpa01 as per MS documentation, temp tables are not officially supported (even though they are present...). MS are looking into the usage scenarios of temp tables currently.

https://learn.microsoft.com/en-us/fabric/data-warehouse/tsql-surface-area

I have a blog which covers what does and doesn't work with the unsupported temp tables in Fabric.

https://www.serverlesssql.com/temp-tables-in-fabric-warehouses/

Forum Discussion

CTAS and temp db

Related content

T-SQL: CTAS with all nullable columns?

Build issues with CTAS statements in Stored procs

MINX with Temp Table

Temp Table

Spark Temp View with two Lakehouses