Snowflake Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Snowflake for replication.
Supported Platforms
- Learn about the Snowflake versions compatible with HVR on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Supported Capabilities
- Discover what HVR offers for Snowflake on our Capabilities for Snowflake page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Data Management
Learn how HVR maps data types between source and target DBMSes or file systems on the Data Type Mapping page. For the list of the supported Snowflake data types and their mapping, see Data Type Mapping for Snowflake.
Understand the character encodings HVR supports for Snowflake on the Supported 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.