0

The Sqitch deploy command fails with below error:-

sqitch deploy 'db:snowflake://amrutmonu:PASSWORD@wea87235.us-east-1.snowflakecomputing.com/DEMO_DB?Driver=Snowflake'

error:

Adding registry tables to db:snowflake://amrutmonu:@wea87235.us-east-1.snowflakecomputing.com/DEMO_DB?Driver=Snowflake 250001 (08001): Failed to connect to DB. Verify the account name is correct: wea "/root/bin/snowsql" unexpectedly returned exit value 1

Could you please look into this and help us fixing this issue?

robsiemb
  • 6,157
  • 7
  • 32
  • 46
Amrut Dengre
  • 1
  • Take a look at this solution [[snowflake] deploy error](https://github.com/sqitchers/sqitch/issues/420#issuecomment-453199324). It works fine for me. Shortly - you have to add some additional settings in snowsql's config file. – IgorKuzenkov Sep 06 '20 at 18:49

1 Answers1

0

Please remove the .snowflakecomputing.com from the connection string, try it out, and let us know how it goes:

sqitch deploy 'db:snowflake://amrutmonu:PASSWORD@wea87235.us-east-1/DEMO_DB?Driver=Snowflake'
Rich Murnane
  • 2,697
  • 1
  • 11
  • 23
  • This time we executed below command - sqitch deploy 'db:snowflake://amrutmonu:PASSWORD@wea87235.us-east-1/DEMO_DB?Driver=Snowflake' But as soon as we hit enter it gives below message - Adding registry tables to db:snowflake://amrutmonu:@wea87235.us-east-1.snowflakecomputing.com/DEMO_DB?Driver=Snowflake and after some 50-55 secs below error message appears - 250001 (08001): Failed to connect to DB. Verify the account name is correct: wea "/root/bin/snowsql" unexpectedly returned exit value 1 – Amrut Dengre Nov 27 '19 at 06:09
  • We checked all the configuration from our end.Nothings seems to be wrong.But still if you want to us to check some particular things in configuration please let us know. Thanks in advance. – Amrut Dengre Nov 27 '19 at 06:14
  • Are you able to access your snowflake account using below URL: https://wea87235.us-east-1.snowflakecomputing.com – Sriga Sep 07 '20 at 05:06