docker-sqitch icon indicating copy to clipboard operation
docker-sqitch copied to clipboard

Snowflake Private Key Authentication not working with .snowsql/conf

Open AshwinSTomar opened this issue 1 year ago • 0 comments

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

AshwinSTomar avatar Jul 24 '24 15:07 AshwinSTomar