24. Temporary Tables in Synapse SQL in Azure Synapse Analytics

In this video, I discussed about temporary tables in dedicated sql pool and server less sql pool in Azure Synapse Analytics

Link for Azure Synapse Analytics Playlist:

Link for Azure Databricks Play list:

Link for Azure Functions Play list:

Link for Azure Basics Play list:

Link for Azure Data factory Play list:

Link for Azure Data Factory Real time Scenarios

Link for Azure LogicApps playlist

#Azure #AzureSynapse #AzureSynapseAnalytics

[jaazv]

Well explained, highlighting the limitations as well.

[deepak]

Ctas is explained very well. Thanks for sharing.

[khushbujain]

Do you provide pdfs which are used in video, they will be beneficial for revision

[MrPatrickfx]

Did you observe if the HASH distribution over a temp table actually really distribution on the column you specify ? By looking afterward the distribution with command like DBCC PDW_SHOWSPACEUSED ? In our case, not sem to create on the distribution specify

[vamsimudragada]

Great! Tutorials
Question - Is there any way to get a list of Temp tables in Synapse via Script?

[alengcm]

Cool. Can I create an external table from a temporary table using CETAS? Looking for hacks.

[sachindubey]

Why we can not just do
Select * into #temp from table1