How Do I Upgrade the Snowflake ODBC Driver on Linux?

Question

How do I upgrade the Snowflake ODBC driver on a Linux-hosted hub? Do I need to stop integration jobs before upgrading?

To upgrade the Snowflake ODBC driver on a Linux-hosted hub:

Confirm whether the hub or an agent machine connects to Snowflake, then upgrade the driver on that machine.
Allow any running refresh jobs to finish, then suspend Snowflake integrate jobs. You do not need to stop the HVR Hub service.
Install the new Snowflake ODBC driver using the Snowflake installer or package.
On Linux and Unix, verify that the driver is registered in odbcinst.ini and that the HVR Snowflake location points at the new ODBC driver name.
Reboot the server only if required by the OS installer. Before rebooting, suspend any remaining running jobs, then restart them afterward.
Resume the integrate jobs after the installation is complete.
Test the Snowflake location connection in the HVR GUI and monitor the integrate logs.
(Optional) Adjust the Snowflake ODBC driver LogLevel according to our guidance. For more information, see Snowflake Requirements.

You can stop and restart the HVR Hub services instead of suspending jobs individually. However, this is not required for the ODBC driver upgrade.