topic Re: How can I set tSnowflakeConnection to connect to different region? in Talend Studio

How can I set tSnowflakeConnection to connect to different region?

wangbinlxx — Thu, 23 Aug 2018 08:48:23 GMT

I'm testing tSnowflakeConnection on my PC, and it fails with the following error.

Exception in component tDBConnection_1
java.lang.RuntimeException: JDBC driver encountered communication error. Message: HTTP status=403.Incorrect Snowflake Account was specified

snowsql(CLI Client)) on my PC works fine.

When I compare snowsql with tSnowflakeConnection , it is very clear that parameter for region is missing from tSnowflakeConnection.

https://help.talend.com/reader/KLsQaMqQC043uxe6RZXYNQ/kFxRzw0aj6_1rFYaVuqEtQ

https://docs.snowflake.net/manuals/user-guide/snowsql-start.html

--region TEXT Snowflake region. US-West (default), US-East: us-east-1, EU (Frankfurt): eu-central-1. Honors $SNOWSQL_REGION.

I can confirm this behavior. My account URL is pointing to ap-southeast-2 . When I run tSnowflakeConnection, it tries to connect to us-west-2 .

How can I set tSnowflakeConnection to connect to different region?

Thanks,

Re: How can I set tSnowflakeConnection to connect to different region?

wangbinlxx — Thu, 23 Aug 2018 08:58:28 GMT

BTW, my Talend version is 7.0.1 .

Re: How can I set tSnowflakeConnection to connect to different region?

wangbinlxx — Mon, 27 Aug 2018 02:31:29 GMT

Solution:

Add the region name into double quotes for 'Account';

If the snowflake URL is AccountName.RegionName.snowflakecomputing.com, add "AccountName.RegionName" into the account field .

Re: How can I set tSnowflakeConnection to connect to different region?

Stephen-Elves — Fri, 17 Apr 2020 14:54:04 GMT

[UPDATE] If you try this solution now then it will fail as there has now been a "Snowflake Region" drop down added.

BUT it only has a limited number of entries.

BUT^2 There is now a "Custom Snowflake Region" option hidden in the "Advanced Settings" tab.