sqitch init snowflake cannot determine Snowflake account name

0
votes

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"

2
snowflake-cloud-data-platformsqitch
Could you please share the error, by seeing the error seems account name is invalid. – Sriga
@Sriga - where is sqitch getting an account name from? – vbp13
By checking sqitch documentation page it is recommended to use project URI like below: sqitch init flipr --uri github.com/sqitchers/sqitch-snowflake-intro --engine snowflake You can refer the documentation page using below link: sqitch.org/docs/manual/sqitchtutorial-snowflake – Sriga
@Sriga that's the first thing i did. same error... the uri is actually not necessary but that's beside the point. – vbp13
From what I can see it looks like sqitch uses the snowSQL config file? or does it have its own file, if so, please check to make sure the account name in those files is only the information before the first "." in your Snowflake instance url. – Rachel McGuigan

2 Answers

1
votes

Sriga provided the documentation for this answer viewed here.

However, to answer your question, to determine the account name, the SnowSQL configuration file needs to be set. To do this you will need to follow the guide on how to set up SnowSQL on the computer establishing a connection to Snowflake.

Make sure you also follow the steps to connect with Sqitch with the documentation provided in the beginning of this post.

1
votes

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