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.3.5, 6.3.0, 6.2.5, 6.2.0, 6.1.5, and 6.1.0).
Supported Capabilities
- Discover what HVR offers for Snowflake on our Capabilities for Snowflake page (6.3.5, 6.3.0, 6.2.5, 6.2.0, 6.1.5, and 6.1.0).
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 key pair and username/password authentication for Snowflake. Use key pair authentication for automated HVR connections that use a Snowflake service user.
For key pair authentication, configure a public key for the Snowflake user and provide the matching private key in HVR. In the CLIENT PRIVATE KEY field, enter the path to the private key. If the private key is encrypted, enter its password in the CLIENT PRIVATE KEY PASSWORD field. For configuration instructions, see Location Connection for Snowflake and Key-pair authentication and key-pair rotation in the Snowflake documentation.
Snowflake is deprecating single-factor password authentication. Its final enforcement phase, scheduled from August through October 2026, blocks non-human users from authenticating with passwords. Username/password authentication remains available in HVR, but Snowflake may reject it based on the user type and enforcement status of the Snowflake account. Use key pair authentication for non-human Snowflake users that connect through HVR to prevent connection failures.
For more information, see Planning for the deprecation of single-factor password sign-ins in the Snowflake documentation.