Connecting to snowflake (Talend does not work with Snowflake)

[DDumas3]

I have connected to Snowflake from other tools. When I click Snowflake, from MetaData=>Snowflake in Talend, I get a connection error. I have filled out the dialog shown in the screenshot attachment.

Dave

[Anonymous]

Hi

What are the error messages? From the screenshot, I see all fields are empty, you need to fill in all the required parameter fields and then click Testing connection button to test the connection.

Regards

Shong

[DDumas3]

Hi Shong,

Screenshot attached. I am happy to do a webex, etc to show you.

Dave

[DDumas3]

I have also subsequently removed the spaces in the Name, but same error.

Dave

[Prakhar1]

Hi @David Dumas​ ,

the account name given in the account field is wrong.

If your URL is "https://abc.snowflakecomputing.com/", then your Snowflake account name is "abc". If you are in any other region (such as AWS US-EAST), then if your URL is "https://xyz.us-east-1.snowflakecomputing.com/", then your account name is "xyz" and select the region option given in the connection(which you have already selected).

[DDumas3]

I changed the account name to the prefix (ours) just before the region (we use azure us east). I also made sure azure us east was selected n the region dropdown. Still getting the same connection error. I have used DBeaver, which is an excellent SQL editor, and that connects fine to our snowflake environment.

[DDumas3]

I also tried using a tJDBC connection component. I chose snowflake for the atabase, and then clicked "Apply". It changed the dialog inputs, which I filled . However, password is grayed out, so cannot enter that. I have attached the error screenshot which says that the password is missing. I have no idea how to get the password input "un-grayed" out. Very frustrating

[DDumas3]

I got the password to input by clicking the .... Now says incorrect username or password error. Here (attached) is how easy it is connect to snowflake using the Dbeaver SQL Editor.

[DDumas3]

Here (attached) is how easy it is connect to snowflake using the Dbeaver SQL Editor. Cannot connect with Talend

[Anonymous]

DBeaver use JDBC way to connect to Snowflake, if you use are tJDBCConnection component in Talend job, click '...' button to fill in the password value, the User Id should be an email address.