tSnowflakeConnection and tSetProxy

[Anonymous]

Hi,

Has anyone got the tSnowflakeConnection to work from a corporate network behind a firewall?

We have to use a HTTP/S Proxy to connect out.

This works fine for connecting for example to S3 as you can click Config client in the Advanced Settings for tS3Connection and set your Proxy Host/Port/Protocol/Username and Password.

The tSnowflakeConnection does not have this functionality and as such i'm getting:

Jun 25, 2018 3:08:22 PM net.snowflake.client.jdbc.RestRequest execute
SEVERE: Got error response: http status=407

I've tried to put a tSetProxy behind the tSnowflakeConnection but there is no way to provide HTTPS proxy connections with a username and password.

Is there any other way of doing this or am I going to have to use a different product such as Matillion to get this done until the tSnowflakeConnection is more fully developed?

Thanks

[Anonymous]

Hello,

Could you please go to  Studio > Window -> Preferences-> General -> Network connections to see if you can set up Studio/jobs to use proxy settings?

Best regards

Sabrina

[Anonymous]

Hi Sabrina,

This is already set and does not seem to get picked up by jobs.

Thanks,

Giles

[Anonymous]

Hi gcar31,

have you tried to setup those vars in Job Level using JVM params?

[Anonymous]

List of params:
-Dhttp.proxySet=true
-Dhttp.proxyHost=<proxy_server_host>
-Dhttp.proxyPort=<proxy_server_port>
-Dhttp.nonProxyHosts=localhost
-Dhttp.proxyUser=<proxy_server_user>
-Dhttp.proxyPassword=<proxy_server_password>
-Dhttps.proxyHost=<proxy_server_host>
-Dhttps.proxyPort=<proxy_server_port>
-Dhttps.proxyUser=<proxy_server_user>
-Dhttps.proxyPassword=<proxy_server_password>