Sqitch deploy to snowflake DW fails

0
votes

The Sqitch deploy command fails with below error:-

sqitch deploy 'db:snowflake://amrutmonu:[email protected]/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?

1
odbcsnowflake-cloud-data-platformunixodbcsnowsqlsqitch
Take a look at this solution [[snowflake] deploy error](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

1 Answers

0
votes

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

sqitch deploy 'db:snowflake://amrutmonu:[email protected]/DEMO_DB?Driver=Snowflake'