Snowflake connection give net.jdbc.SQLException with incorrect username or password was specified

[Anonymous]

Talent Studio - cloud 7.3.1 TRIAL Version

Cannot connect to SNOWFLAKE. I am able to connect using the design mode. When I give test connection, IDE brings back the tables/schema related to that connection. But when I run the job with the same connection from the meta it fails with an exception report stating

"Exception in component tDBConnection_1 (APP1_POC)

java.lang.RuntimeException: net.snowflake.client.jdbc.SnowflakeSQLException: Incorrect username or password was specified."

I would highly thank anybody who would give a solution to the above. Thank you so much.

[manodwhb]

@soadevelopers, as per the error your user name or password incorrect, please re-check username and password.

[Anonymous]

Thank you for the quick response @manodwhb 

Like I said, if either would have been wrong IDE will not bring the tables/schema from snowflake right?

This is happening at runtime. I thought once I configure the user/pwd in ide properties window i can just run. 

Please let me know.

Thank you. 

Soadeveloper

[manodwhb]

@soadevelopers, can you please share screen shoots to understand better your issue?

[Anonymous]

 Here is the exception thrown on the IDE

I have one connection, one csv converter (CSV IS WORKING FINE)

Converted connecting to tSnoflakeconnection or tdbconnetion where i pick snowflake from db property

Please see the screenshot. Basically just one connection being put as a job also it simply gives the same exception constantly. 

Thank you for the response.

talenderror.png

[manodwhb]

@soadevelopers, can you share a screenshot of the component too?

[Anonymous]

@manodwhb 

Here it is attached. Like I said, its very simple. In IDE during development it is correctly bringing the schemas from snowflake. So username pwd and jdbc url all working in design time. But when I run it fails.

Screen shot attached as requested. 

talendidescreen.png

[Anonymous]

can somebody help please?

[manodwhb]

@soadevelopers, when you created metadata connection in Talend repository its working and when running the job it is failing ? is that your statement? 

[Anonymous]

Yes. Exactly. 

When running the job it is NOT Working. Correct. 

Thank you.

S