question

$$ANON_USER$$ avatar image
0 Votes"
$$ANON_USER$$ asked $$ANON_USER$$ commented

Temporary table in Azure Synapse Pipeline with Data flow

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

azure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered $$ANON_USER$$ commented

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.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello PRADEEPCHEEKATLA-MSFT,
I would like to use them at the level of my dataflows during transformations. There are no other solutions?
Thank you in advance,
Pierre

0 Votes 0 ·

Hello @Pierre2021,

Unfortunately, it is not possible to use temporary tables in Azure Synapse with Data Flows.

Hope this helps.

1 Vote 1 ·
$$ANON_USER$$ avatar image $$ANON_USER$$ PRADEEPCHEEKATLA-MSFT ·

Thank you

0 Votes 0 ·