topic Re: Connecting to snowflake (Talend does not work with Snowflake) in Talend Studio

Connecting to snowflake (Talend does not work with Snowflake)

DDumas3 — Tue, 14 Dec 2021 00:14:25 GMT

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

Re: Connecting to snowflake (Talend does not work with Snowflake)

Anonymous — Tue, 14 Dec 2021 01:04:23 GMT

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

Re: Connecting to snowflake (Talend does not work with Snowflake)

DDumas3 — Wed, 15 Dec 2021 22:43:30 GMT

Hi Shong,

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

Dave

Re: Connecting to snowflake (Talend does not work with Snowflake)

DDumas3 — Wed, 15 Dec 2021 22:46:02 GMT

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

Dave

Re: Connecting to snowflake (Talend does not work with Snowflake)

Prakhar1 — Thu, 16 Dec 2021 09:58:54 GMT

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).

Re: Connecting to snowflake (Talend does not work with Snowflake)

DDumas3 — Thu, 16 Dec 2021 15:36:57 GMT

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.

Re: Connecting to snowflake (Talend does not work with Snowflake)

DDumas3 — Thu, 16 Dec 2021 17:12:18 GMT

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

Re: Connecting to snowflake (Talend does not work with Snowflake)

DDumas3 — Thu, 16 Dec 2021 17:45:32 GMT

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.

Re: Connecting to snowflake (Talend does not work with Snowflake)

DDumas3 — Thu, 16 Dec 2021 17:47:40 GMT

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

Re: Connecting to snowflake (Talend does not work with Snowflake)

Anonymous — Fri, 17 Dec 2021 02:33:41 GMT

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.

Re: Connecting to snowflake (Talend does not work with Snowflake)

DDumas3 — Fri, 17 Dec 2021 14:12:08 GMT

I also tried the JDBC connector, and used the ... elipse to to enter the password. Yes, my user id is the email address. Same error result - "invalid username or password". I do not know what else to try. Dbeaver was "dead easy" to connect to Snowflake - as it should be.

Re: Connecting to snowflake (Talend does not work with Snowflake)

DDumas3 — Fri, 17 Dec 2021 14:13:58 GMT

Is there any possible way you can help me to get this fixed? My Parent company is evaluating ETL tools, and will be counting on me for any input on Talend working with Snowflake. I am happy to do a webex.

Re: Connecting to snowflake (Talend does not work with Snowflake)

DDumas3 — Thu, 23 Dec 2021 15:21:06 GMT

Shong - no response to all this?