I am using a private key authentication to connect to Snowflake and cannot connect using Sqitch. This is working successfully when connecting directly using snowsql.
My connect string looks like this:
sqitch status -vvv db:snowflake://[email protected]/POC_DB?Driver=Snowflake;authenticator=SNOWFLAKE_JWT;priv_key_file=/Users/username/rsa_key.p8;priv_key_file_pwd=xxxxxx;warehouse=DEFAULT_WH;uid=username
Have masked real values where needed, but these are correct as same as work direct with snowsql.
Using the -vvv option I see
[Snowflake][DSI] (20032) Required setting 'PWD' is not present in the connection settings. (SQL-28000)
and
trace: DBI::connect('DBI', 'dbi:ODBC:Server=myaccount.snowflakecomputing.com;Port=443;Database=POC_DB;Driver=Snowflake', 'username', undef, 'HASH(0x7fed7a719230)')
indicating password is "undef".
The sqitch.conf in ~/.sqitch is setup as shown here https://sqitch.org/docs/manual/sqitch-authentication/ under the don't use passwords section.
I cannot solve why it is giving me the missing PWD error, when working with snowsql?
thanks.
