Currently supported databases by Sqitch’s database change management tool include Snowflake’s Cloud Data Warehouse as well as PostgreSQL 8.4+, SQLite 3.7.11+, MySQL 5.0+, Oracle 10g+, Firebird 2.0+, Vertica 6.0+, and Exasol 6.0+.
When you run the command
sqitch init widgets --engine snowflake
It throws an error as “Cannot determine Snowflake Account Name“
Its a known issue : It states that Sqitch can’t find an account code . Without an account code you can’t connect to Snowflake.
There is a workaround, you can set the $SNOWSQL_ACCOUNT environment variable as below.
SNOWSQL_ACCOUNT=account_xxx ./t/sqitch init foo --engine snowflake
You can refer how to configure the snow sql from here https://docs.snowflake.com/en/user-guide/snowsql-config.html
Alternatively you can try this ( We didnt test this )
Create a snowsql config file without default values.
you can specify -a MY_ACCCOUNT_NAME
if the accountname property is not set in the snowql config -> sqitch will NOT work.
set the “MY_ACCCOUNT_NAME” property in the snowsql config–> sqitch will work.