Temporary table in Azure Synapse Pipeline with Data flow

Question

Hello,
I want doing : the passage of data from one dataflow to another with the use of temporary tables in azure synapse and data flow but temporary table (ie, #TemporaryTable) not visible.
I use synapse pipeline with sql pool, not serveless . i use data flow
Are there no other alternatives with temporary tables?
I want use temporary tables to split dataflows.
Thank you

Answer 1

Hello @Pierre2021 ,

Welcome to the Microsoft Q&A platform.

Temporary tables are only visible to the session in which they were created and are automatically dropped when that session logs off.

What are temporary tables?

Temporary tables are useful when processing data, especially during transformation where the intermediate results are transient. In dedicated SQL pool, temporary tables exist at the session level.

For more information, refer to Temporary tables in dedicated SQL pool.

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.