Error to connect with Snowflake Cloud

[Anonymous]

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?

[Anonymous]

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

[manodwhb]

@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

[Anonymous]

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?

[manodwhb · Accepted solution]

@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

[Anonymous]

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

[manodwhb]

@erjorgea , I'm glad to help you.