Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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,
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 .
BTW, my Talend version is 7.0.1 .
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 .
[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.