As I want to connect to snowflake within our corporate network (VPN), I need to add our ssl certificates when connecting to snowflake. I am not an expert on this, but when using the Windows built-in ODBC connection administration adding the certificates to the file to which the "CABundleFile" path within the registry points at, this was what allowed me connect. Same for connecting with IntelliJ, which for Snowflake has the option to add certificates within the SSL tab (if you want to compare), which also allowed me to connect.
This is the error I am getting:
[1642061745639] ERROR (ls): Connecting error: {"code":401001,"data":{"driver":"Snowflake","driverOptions":{}},"name":"NetworkError"} ns: "conn-manager" [1642061745640] ERROR (ext): ERROR: Error opening connection Network error. Could not reach Snowflake., {"code":401001,"data":{"driver":"Snowflake","driverOptions":{}}} ns: "error-handler"
I can rule out that there is any other issue with the configuration as it works when I turn of the corporate VPN.
As I want to connect to snowflake within our corporate network (VPN), I need to add our ssl certificates when connecting to snowflake. I am not an expert on this, but when using the Windows built-in ODBC connection administration adding the certificates to the file to which the "CABundleFile" path within the registry points at, this was what allowed me connect. Same for connecting with IntelliJ, which for Snowflake has the option to add certificates within the SSL tab (if you want to compare), which also allowed me to connect.
If I understand correctly, the postgres connector supports this within a ssl part of the config: https://node-postgres.com/features/ssl
This is the error I am getting:
[1642061745639] ERROR (ls): Connecting error: {"code":401001,"data":{"driver":"Snowflake","driverOptions":{}},"name":"NetworkError"} ns: "conn-manager" [1642061745640] ERROR (ext): ERROR: Error opening connection Network error. Could not reach Snowflake., {"code":401001,"data":{"driver":"Snowflake","driverOptions":{}}} ns: "error-handler"I can rule out that there is any other issue with the configuration as it works when I turn of the corporate VPN.