snowflake-cloud-data-platformsqitch

sqitch init snowflake cannot determine Snowflake account name

I'm following the sqitchtutorial-snowflake tutorial and getting stuck when initializing a sqitch project

When i run sqitch init widgets --engine snowflake

The terminal indicates, "Cannot determine Snowflake account name"

Solution

  • Ugh, sounds like a defect in Sqitch. It complains if it can't find an account code, since without an account code one cannot connect to Snowflake. However, it should suppress that error when the command won't be connecting to Snowflake, as in the init command.

    Here's a bug report; we should get it fixed before v1.0.1.

    In the meantime, setting up the SnowSQL config file as mentioned in comments here is a decent workaround, but you can also set the $SNOWSQL_ACCOUNT environment variable, e.g.,

    SNOWSQL_ACCOUNT=xxx ./t/sqitch init foo --engine snowflake