Sqitch Snowflake using key-pair authentication

Question

I have installed Sqitch on a Windows 10 PC using Strawberry Perl. My Snowflake environment has key-pair authentication set up. My sqitch.conf file has a target set up with the uri.

I am following the Sqitch tutorial and am just trying to create a schema in a DB

When I run this command: c:\Projects\Sqitch\flipr>sqitch deploy

It shows this output: Adding registry tables to db:snowflake://xxx@xxx.eu-west-1.snowflakecomputing.com/flipr?Driver=SnowflakeDSIIDriver;authenticator=SNOWFLAKE_JWT;priv_key_file=/xxx/rsa_key.p8;priv_key_file_pwd=xxx;warehouse=xxx;uid=xxx

(xxx obviously masks any sensitive values)

It then just sits there doing nothing. I've left it for at least 30 mins so it's definitely not going to complete. If I kill it (ctrl+C) then it shows this - which implies that snowsql is running but it is either not executing properly or not shutting down properly and returning control to Sqitch:

Aborted! "C:\Program Files\Snowflake SnowSQL\snowsql.exe" unexpectedly returned exit value 1

Does anyone have any idea what the problem is?

Answer 1

Fixed by amending the ODBC - server needed the full URL (including .snowflakecomputing.com) and I just had the account/region