topic Re: Error to connect with Snowflake Cloud in Talend Studio

Error to connect with Snowflake Cloud

Anonymous — Thu, 04 Jun 2020 10:43:04 GMT

Hi,

I am new using Talend . and I would like to connect with SnowFlakeCloud, I use component "Snowflake Connection", but gives me an error:

net.snowflake.client.jdbc.SnowflakeSQLException: Incorrect username or password was specified.

I use this settings:

user:jn87085.eu-west-1
password: YYY
Schema: TPCH_SF1
Database: SNOWFLAKE_SAMPLE_DATA

Can anyone help me please?

Re: Error to connect with Snowflake Cloud

Anonymous — Thu, 04 Jun 2020 11:04:32 GMT

HI,

now I can log in, but gives me a different error:

error jcbd driver encounterded communication error:messahe http status=403

Can anyone help me

Re: Error to connect with Snowflake Cloud

manodwhb — Thu, 04 Jun 2020 11:36:45 GMT

@erjorgea ,check the account name.please check the below link .i belive you have account is wrong.

https://docs.snowflake.com/en/user-guide/connecting.html

Re: Error to connect with Snowflake Cloud

Anonymous — Thu, 04 Jun 2020 12:30:38 GMT

Hi Manowar,

when I enter to Snowflake in web version I use my alias: erjorgea. and my url is:

https://jn87085.eu-west-1.snowflakecomputing.com/

When I try to connect with talend, I use the firts leg part of the url until snowflakecomputing.com

UserId: jn87085.eu-west-1

pass: same password as used in snowflake version

schema: PUBLIC

database: SNOWFLAKE_SAMPLE_DATA

but it gives me the same error.

I read the document you mentioned, and put the user with the correct server

any idea?

Re: Error to connect with Snowflake Cloud

manodwhb — Thu, 04 Jun 2020 12:39:12 GMT

@erjorgea , use like below way and let me know

Account:jn87085

UserId:same userid as used in snowflake version

pass: same password as used in snowflake version

Warehouse: check what is your Warehouse what is it

schema: PUBLIC

database: SNOWFLAKE_SAMPLE_DATA

Re: Error to connect with Snowflake Cloud

Anonymous — Thu, 04 Jun 2020 12:50:34 GMT

Thanks Manowar,

now is connected correctly.

My problem was that in Account field I wrote another word, I have no idea that in this field is necessary to write the Snowflake account.

Is a beginner mistake.

Thanks soo much Manodwhb

Re: Error to connect with Snowflake Cloud

manodwhb — Thu, 04 Jun 2020 12:53:30 GMT

@erjorgea , I'm glad to help you.