docker-sqitch
docker-sqitch copied to clipboard
Snowflake Private Key Authentication not working with .snowsql/conf
I am trying to use private key authentication for my sqitch user with snowflake and following the document: https://sqitch.org/docs/manual/sqitch-authentication/
set the following variables in the ~/.snowsql/config file:
authenticator = SNOWFLAKE_JWT private_key_path = "path/to/privatekey.p8"
But just making the above change is not working and it throws the bellow error:
[Snowflake][DSI] (20032) Required setting 'PWD' is not present in the connection settings. (SQL-28000)
To make it work I added the below params to the uri string: authenticator=SNOWFLAKE_JWT;priv_key_file=path/to/privatekey.p8
Is it a bug or we have to make changes to both the snowsql config and sqitch config?
Regards, Ashwin