Blog Post

Azure Data Factory Blog
1 MIN READ

ADF now supports data integration with Snowflake

Linda_Wang's avatar
Linda_Wang
Icon for Microsoft rankMicrosoft
Jun 08, 2020
Azure Data Factory provides 90+ built-in connectors allowing you to easily integrate with various data stores regardless of variety of volume, whether they are on premises or in the cloud.   We a...
Updated Aug 31, 2020
Version 4.0
azure data factory
Azure Data Integration
BenMcIntyre's avatar
BenMcIntyre
Copper Contributor
Jun 18, 2020

We are trying to connect to a snowflake instance but are receiving errors while setting up the connection in ADF.

 

If using the Azure hosted Integration Runtime we receive the following exception when testing the connection: 

CURLerror (curl_easy_perform() failed) - code=51 msg='SSL peer certificate or SSH remote key was not OK' osCode=13 osMsg='Permission denied'

If using a self hosted Integration Runtime we get:

CURLerror (curl_easy_perform() failed) - code=60 msg='Peer certificate cannot be authenticated with given CA certificates' osCode=2

There are no SSL certificate errors when trying to access the database through the browser. The host is on xxxxxxx.eu-central-1.snowflakecomputing.com.

 

Have you come upon this error before? Any pointers?