Snowflake Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Snowflake for replication.
For information about compatibility and supported versions of Snowflake with HVR platforms, see Supported Platforms.
For the Capabilities supported by HVR on Snowflake, see Capabilities for Snowflake.
For information about the supported data types and mapping of data types in source DBMS to the corresponding data types in target DBMS or file format, see Data Type Mapping.
For the character encodings supported by HVR on Snowflake, see the Character Encodings page.
Due to technical limitations, external staging on Azure for Snowflake is not supported in the HVR releases since 6.1.5/3 to 6.1.5/9.
ODBC Connection
HVR requires that the Snowflake ODBC driver is installed on the machine from which HVR connects to Snowflake. For more information on downloading and installing Snowflake ODBC driver, see Snowflake Documentation. For information about the supported ODBC driver version, refer to the HVR release notes (hvr.rel) available in the HVR_HOME directory or the download page.
After installing the Snowflake ODBC driver, configure the LogLevel configuration parameter as specified in ODBC Configuration and Connection Parameters of the Snowflake Documentation.
Snowflake Authentication
HVR supports both username/password and certificate-based authentication for Snowflake.
For certificate-based authentication, Snowflake requires a Key Pair, which includes a private key (Database_Client_Private_Key) and password (Database_Client_Private_Key_Password). Steps to create a Key Pair are described in the Snowflake Documentation.