Unable to load data into Snowflake using Connector

  • 395Views
  • Last Post 22 December 2022
0
votes
anastasiya.tretyak posted this 09 November 2022

We have tried importing data from Azure SQL and CSV file and keep getting an ERROR 16 and failed load. Can you please help debug? We have checked all permissions on Snowflake side and can see that the designated role can insert data into tables. 

Order By: Standard | Newest | Votes
0
votes
Support Skyvia posted this 10 November 2022

Hi,

Thank you for contacting Skyvia Support.

 

After a closer look at your situation, we would like to ask to share some information with us so we can reproduce it on our side.

Do you mind sending along your CSV file example and a Data Definition Language script that was used for creating a table in Snowflake? 

Also, we would like to have your permission to perform test runs of your packages.

 

We look forward to hearing from you. 

 

Best regards,

Serhii

Technical Support Engineer

0
votes
Support Skyvia posted this 10 November 2022

 Hi Anastasiya,

 

We hope you are well!

 

Please disregard our previous message. We have managed to reproduce the issue on our side. The team is working on a resolution. 

We will get back to you once it's resolved.

 

Best regards,

Serhii

Technical Support Engineer

0
votes
anastasiya.tretyak posted this 24 November 2022

Hello!

Serhii, thank you for your reply! I'm wondering if you have any updates about the Snowflake connector. It's kind of a blocker for us now  

Thank you, 
Best regards, 
Nastya

0
votes
Support Skyvia posted this 24 November 2022

Hi,

We are really sorry for the inconvenience. 

The team has fixed the issue. It will be available after the coming update on our side.

Please rest assured that we will inform you about the update right away.

Thanks for your patience with this request!

 

Best regards,

Serhii

Technical Support Engineer

0
votes
Support Skyvia posted this 22 December 2022

 Hi Anastasiya, 

 

Thanks for your time and patience on this request. 

 

Please be informed that your issue is fully resolved now and you can use all the features of our product.  

 

In case you will get any additional questions, simply submit a new request.

 

Best regards, 

Serhii

Close