CODEWITHSUNDEEP
azureazure-data-factoryazure-data-lakeazure-synapse
samyak jain
samyak jain

Reputation: 3

Error while loading data from ADLS Gen2 to Azure Synapse

I am trying to perform a copy activity from ADLS Gen2 to Azure Synapse warehouse using polybase direct copy. while copying i am getting the error like :

" Please make sure SQL DW has access to ADLS Gen2". but why does it need access to ADLS Gen2 when data factory can take care of it? and also how do i give that access if i need to give that.

Thanks.

Upvotes: 0

Views: 1004

Answers (1)

suziki
suziki

Reputation: 14108

On my side, I can success copy.

You can check the whether the settings is different bettween your and mine.

This is the firewall settings of my sql server:

enter image description here

I didn't set any firewall limit, I allow my client IP and other azure service to access my sql server.

And this is my copy activity:

enter image description here enter image description here

This pipeline works fine:

enter image description here enter image description here

Upvotes: 0

Related Questions