migrate data from dedicated SQL pool into data lake gen2

Question

migrate data from dedicated SQL pool into data lake gen2

MUSTAFA AHMAD MUSTAFA AL-HUNAITI 176

hello guys i want to ask about how can i extract data from tables in databases in azure synapse analytics dedicated sql pool to container in azure data lake gen2

solution i want to do: i want to use copy activity in a pipeline to do this

if this right, can someone help me what configration i must do in copy activity to complete task

1 answer

Your answer

Answer 1

Nandan Hegde 36,146 MVP Volunteer Moderator

Below blog can act as refrence: https://mayur-saparia7.medium.com/how-to-copy-data-from-azure-sql-to-blob-storage-as-csv-file-69058555ced3

You need to update the source from Azure SQL database to synapse analytics pool

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-02-15T23:35:29.5166667+00:00

Thank you, @Nandan Hedge ,

Hello @MUSTAFA AHMAD MUSTAFA AL-HUNAITI,

I am checking to see if the above answer from Nandan helped here.

If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions

Share via

migrate data from dedicated SQL pool into data lake gen2

1 answer

Your answer