Location Connection for Snowflake
This section describes the connection details required for creating Snowflake location in Fivetran HVR. For information about the pre-requisites, access privileges, and other configuration requirements for creating Snowflake location, see Snowflake Requirements.
If the managed secrets feature is enabled, option USE TOKEN INSTEAD is displayed in the fields designated for entering secrets.
| Field | Description | Equivalent Location Property |
|---|---|---|
| SERVER | Hostname or IP-address of the server on which Snowflake connection is running. Example: www.snowflakecomputing.com | Database_Host |
| PORT | Port number on which the Snoflwake server is expecting connections. Example: 4323 | Database_Port |
| ROLE | Name of the Snowflake role. Example: admin | Snowflake_Role |
| WAREHOUSE | Name of the Snowflake warehouse. Example: mysnowflakewarehouse | Snowflake_Warehouse |
| DATABASE | Name of the Snowflake database. Example: mytestdb | Database_Name |
| SCHEMA | Name of the default schema to be used for this connection. Example: mysnowflakeschema | Database_Schema |
| USER | Username for connecting HVR to the Snowflake database . Example: hvruser | Database_User |
| AUTHENTICATION METHOD | Authentication method for connecting HVR to a Snowflake server. Available options are:
| |
| PASSWORD | Password for the Database_User. This field is enabled only if AUTHENTICATION METHOD is set to Password. | Database_Password |
| CLIENT PRIVATE KEY | Directory path where the .pem file containing the client's SSL private key is located. This field is enabled only if AUTHENTICATION METHOD is set to Key Pair. | Database_Client_Private_Key |
| CLIENT PRIVATE KEY PASSWORD | Password of the client's SSL private key specified in Database_Client_Private_Key. This field is enabled only if AUTHENTICATION METHOD is set to Key Pair. | Database_Client_Private_Key_Password |
Advanced Settings
| Field | Description | Equivalent Location Property |
|---|---|---|
| LINUX / UNIX ODBC DRIVER MANAGER LIBRARY PATH | Directory path where the ODBC Driver Manager Library is installed. This field is applicable only for Linux/Unix operating system. For a default installation, the ODBC Driver Manager Library is available at /usr/lib64 and does not need to be specified. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/lib. | ODBC_DM_Lib_Path |
| LINUX / UNIX ODBCSYSINI | Directory path where the odbc.ini and odbcinst.ini files are located. This field is applicable only for Linux/Unix operating system. For a default installation, these files are available at /etc directory and do not need to be specified using this field. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/etc. The odbcinst.ini file should contain information about the Snowflake ODBC Driver under the heading [SnowflakeDSIIDriver]. | ODBC_Sysini |
| ODBC DRIVER | Name of the user defined (installed) ODBC driver used for connecting HVR to the Snowflake Database. | ODBC_Driver |
Staging
HVR supports staging for Snowflake location. For information about the location properties for staging, see Staging for Snowflake.