Unable to load data in dedicated SQL pool while using data flow in azure synapse analytics?

Anonymous
2022-06-03T16:36:02.123+00:00

Hi Team,
I am new to azure and my requirement is I am loading the data from ADLS folder to Dedicated SQL Pool.

I am able to copy data but now I want whatever files which are coming as source in my ADLS folder should move to other archive folder and delete from the source folder while I run the pipeline from synapse and the target data will be my dedicated sql pool database table.

I tried it doing using data flow but when i am selecting sink it is not giving me the option of dedicated sql pool.

1). How can we achieve the above scenario if data flow does not work?
2). While using the wildcards because i need to load files in bulk, my existing folder is not showing that is the reason it is not deleting files from the source folder?

My source files are JSON files.

Any help would be really appreciated!

Thanks in advance.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,343 questions
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.
2,641 questions
No comments
{count} votes

Accepted answer
  1. Subashri Vasudevan 4,621 Reputation points
    2022-06-04T15:56:37.357+00:00

    Hi anonymous user ,

    Thanks for posting your query on Microsoft Q&A platform.

    you are right, Please check this post for the steps to use dedicated SQL pool in sink.

    Please revert should you have more questions.

    Thanks.


0 additional answers

Sort by: Most helpful