Having trouble getting sqitch running on Windows

[itsbriankim]

I was able to get sqitch running a few weeks ago and even deployed a change but for some reason, I'm having trouble getting it up and running again. I'm on Windows, so the documentation is pretty sparse on exact details.

I'm not even sure where/what I should be running to properly get sqitch up, but I've done a mix of running the executable sqitch.bat and spinning up the sqitch docker container. When I try to run various commands like .\sqitch.bat status or .\sqitch status I get the following message:

On database db:snowflake: DBD::ODBC 1.59 required to manage Snowflake

When I try to target my database, like this:
.\sqitch status --target my_test_db

I get this:

On database my_test_db DBD::ODBC 1.59 required to manage Snowflake

I have the updated Snowflake driver, as I downloaded it about a month ago and got this working a few weeks ago. Where do I figure find the Snowflake driver that sqitch is attempting to use? Or could this be an environment variable path issue? If so, what am I supposed to add there? Any insight would be helpful, thanks!

[theory]

How did you build Sqitch? The Docker image includes DBD::ODBC.

[itsbriankim]

Yeah I'm building from the Docker image. Where exactly in it is DBD::ODBC configured? I'm trying to run this with Snowflake if that matters as well

[itsbriankim]

Is there a chance I would be getting this error if the Docker container can't connect to the database? MFA is required on my Snowflake account, so I'm wondering if that could be the issue, even though the error message doesn't exactly indicate that. I'm stumped because this was working just a few weeks ago and I've exhausted all my options

[theory]

The --with-odbc option here adds it to the base image. Are you building the Snowflake image form these instructions?

If not, DBD::OBC won't load from the base image unless you also install unixodbc. I just tested it out on the base Sqitch image:

# perl -I/usr/lib/perl5 -MDBD::ODBC -E 'say DBD::ODBC->VERSION'
Can't load '/usr/lib/perl5/aarch64-linux-gnu-thread-multi/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC: libodbc.so.2: cannot open shared object file: No such file or directory at /usr/lib/aarch64-linux-gnu/perl-base/DynaLoader.pm line 201.
 at -e line 0.

# apt update
# apt install --no-install-recommends  unixodbc
# perl -I/usr/lib/perl5 -MDBD::ODBC -E 'say DBD::ODBC->VERSION'
1.61

Sqitch requires DBD::ODBC to load the Snowflake ODBC driver so it can maintain its registry tables.

[theory]

No, failure to connect would be a different error.

[itsbriankim]

Didn't realize I had to follow those instructions, thanks. Had to only update the SQITCH_IMAGE in the docker-sqitch.bat file to refer to the Snowflake-specific image. Is updating the sf_account variable optional? I didn't do that and was still able to get this running fine, so I'm not sure if I missed something there

[theory]

No, that just sets a default account name. Probably should remove it TBH.