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?
Could you please go to Studio > Window -> Preferences-> General -> Network connections to see if you can set up Studio/jobs to use proxy settings?
Could you please let us know if this practice mentioned in topic https://community.talend.com/t5/How-Tos-and-Best-Practices/bd-p/howto_bestpractice is helpful for you?
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.