Connection Talend with Snowflake by using a proxy

[Anonymous]

Good Morning, 

i have a problem connecting Talend 7.0.1 with a Snowflake account. 

I created a connection with Snowflake by using the JDBC driver 3.6.9 and the "Test Connection" works well. 

But the DataFlow stops downloading the OCSP certification because Talend cannot arrive to the URL of the certification.

In my network I use a proxy. 

That URL is reachable from Browser using the proxy together with the URL of Snowflake. 

The Stack TRACE is attached.

I read that i have to insert in the whitelist of the proxy the OCSP*.snowflake.com but also this try doesn't work.

Can you help me?

Thanks

[manodwhb]

@giuseppe ,i have faced the same issue,since i have used my home network it went well,it is network problem. can you try with other network and you can ask network team to fix this issue.

[Aukema]

You can add your proxy settings to Talend Studio configuration (.ini) file. See here fore details:

https://help.talend.com/reader/QMX8CbfkO_bqsnP~JJ4I6A/FwIRsowklEifL8r0UTznvg

The TAC configuration settings are documenten here:

https://help.talend.com/reader/3Bhko2hxGTu5XaUr1gobtA/AJWbAC0Ex5U6Is~U3OMSug

[Anonymous]

I added my Proxy information in the VM that I'm using but this doesn't solve the problem.

I tried also the native connector with the Snowflake, but Talend ask me to install the components-snowflake-0.23.2 which ask me to insert the region server. 

The result is that during the compilation of the job i have an error because the regionServer is not found as a variable.

In attached the error script

Image7.png

[manodwhb]

@giuseppe ,can you show me he job design and snowflake connection component configuration? you should specify the the region which available from the drop down list.

[Anonymous]

use the url below without quotes:

jdbc:snowflake://<server details>?user=<name of the role>&warehouse=<warehouse name>&db=<database name>&schema=<schema name>&role=<role name>

In the talend help center the role at the last has not been mentioned to add, its just till schema that has been mentioned.

Also, try not to put the jdbc connection string in quotes, it worked for me. please check the screenshot and follow the steps, 

mark kudos it it works for you 

install the latest driver if the driver error occurs, as in this case. 

put every fields without quotes and try

Capture.PNG