Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,608 questions
SQL To Snowflake ADF dta load issue
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Operation on target Copy data1 failed: ErrorCode=UserErrorUnclassifiedError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Odbc Operation Failed.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.IndexOutOfRangeException,Message=region_group,Source=System.Data,'
I am getting the above error
Source is Azure SQL
Sink is snowflake
Linked service is a blob
Data gets loaded in Temporary file in Blob, but while pushing it to Snowflake this error occurs
Azure Data Factory
{count} votes
-
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator2021-09-20T06:37:59.66+00:00 Hi @Anonymous ,
Thank you for posting query in Microsoft Q&A Platform.
Could you please help to share details on below clarifications to understand issue better,
- Could you please share your copy activity configurations?
- Is your sink data set pointing to Snowflake? Is test connection is successful there?
- Which type of integration runtime you are using in Source and Sink linked services?
-
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
2021-09-22T05:05:53.64+00:00 Hi @Anonymous ,
Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.
-
Anonymous
2021-09-23T11:48:39.373+00:00 hi,
pls find details below
Could you please share your copy activity configurations? src is Azure SQL db(data gets picked)- stage is Blob(temp file gets created)- sink is Snowflake(This is where the error occurs
Is your sink data set pointing to Snowflake? Is test connection is successful there?yes, test connection is successful
Which type of integration runtime you are using in Source and Sink linked services?for SRC- AutoResolveIntegrationRuntim
for target- i tried with both AutoResolveIntegrationRuntim and selfhosted, it doesnt work..If i use ODBC connector pointing to SF , it works fine. But with the Snowflake linkedservice it gives me this error
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 39%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DMMDM 1 Reputation point2021-09-23T20:58:52.07+00:00 We are facing the same issue, sharing details
Could you please share your copy activity configurations?
- Azure SQL as source
- Snowflake as sink
- Mapping
- setting tab
Is your sink data set pointing to Snowflake? Is test connection is successful there?
Yes. Test connection is successful.
Which type of integration runtime you are using in Source and Sink linked services?
Auto Ressolve Integration Runtime.
Note: We are facing the same issue while copying from blob/postgresql to snowflake
-
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
2021-09-29T11:28:23.203+00:00 Hi @Anonymous ,
Following up to see if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further. -
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
2021-09-29T11:30:26.777+00:00 Hi @DMMDM ,
This may be happening because of large dataset? Could you please feel free to raise it as new question to dig more into this?
Sign in to comment
Sign in to answer