Temporary table in Azure Synapse Pipeline with Data flow

Anonymous
2021-08-17T16:51:46.31+00:00

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
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,472 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 79,546 Reputation points Microsoft Employee
    2021-08-18T07:57:43.897+00:00

    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.


0 additional answers

Sort by: Most helpful