Unable to obtain connection from database, Private key provided is invalid or not supported

malyalamv

I am using the flyway/flway:latest  image 

i am not able to connect to snowflake using the private key, below is the FLYWAY_URL used
jdbc:snowflake://***.snowflakecomputing.com/?warehouse=***&db=***&schema=***&role=***&user=***&authenticator=snowflake_jwt&private_key_file=./id_rsa/snowflake_rsa_key.p8&private_key_file_pwd=***

Is there a sample docker run command using the private key connection that can be shared ?

AlistairW

No specific docker instructions but there are some general instructions on key based authentication at the bottom of the DB documentation page (there are a number of moving pieces on both sides): https://documentation.red-gate.com/fd/snowflake-184127607.html
If you are still having problems then could you post the log output (ideally using the -X option on the flyway call)

jeffreestar

To connect to Snowflake using a private key with the Flyway Docker image, you need to ensure that the private key file and any MapQuest Route Planner related credentials are correctly provided and accessible to the Docker container

Finnianflyn

AlistairW said:

No specific docker instructions but there are some general instructions on key based authentication at the bottom of the DB documentation page (there are a number of moving pieces on both sides): https://documentation.red-gate.com/fd/strands hint-184127607.html
If you are still having problems then could you post the log output (ideally using the -X option on the flyway call)

Thank you for providing that information. It is great!