Azure Data Factory is one of the widely used Data Integration tools for Snowflake and is used to copy and transform data. It integrates with Snowflake natively as a Source and as a Sink. As of this date, Data Factory supports secure authentication using a Snowflake account through passwords. Azure Key Vault can be utilized for managing the passwords in Data Factory.
This article describes the workaround method for connecting to Snowflake from Azure Data Factory using Key-pair Authentication. It uses Snowflake's ODBC driver with self-hosted integration runtime to connect via Key-pair authentication.
The additional connection parameters PRIV_KEY_FILE and PRIV_KEY_FILE_PWD for the ODBC driver needs to be updated in the registry under the path HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<DSN_NAME> for system DSN.
For more information on setting the Parameters in Windows, please refer to the Setting Parameters in Windows from Snowflake User Guide. For additional information on ODBC connection Parameters, please refer to Snowflake’s User Guide.
The ODBC Linked Services can be created with the System DSN and can be utilized by the Datasets. For more information on Snowflake with Azure Data Factory, please refer to Copy and transform data in Snowflake using Azure Data Factory or Azure Synapse Analytics.
The ODBC connector does not support all the features of the native Snowflake connector. The recommendation is to leverage native Snowflake connector in Data Factory.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.