Lakehouse Federation - Unable to connect to Snowflake using "PEM Private Key"

saiV06
New Contributor III

‎02-27-2025 11:38 AM

Hi,

I'm currently using Lakehouse Federation feature on databricks to run queries against Snowflake datawarehouse. Today I'm using a service credential to establish the connection (user id & pwd), but I have to change it to use private key. I tried using the "PEM Private Key" option, but it would never let me make the connection. Although, when I try to use the same key value from python it works. Attached the screenshot of the error message I'm getting. Can someone please assist on this?

Thanks!

0 Kudos

pradeep_singh
Honored Contributor III

‎03-25-2026 05:50 AM

Can you check if you have encrypted your keys . The Snowflake JDBC driver does not support authentication with encrypted private keys.  
https://docs.databricks.com/aws/en/query-federation/snowflake-pem#limitations
Try generating the key with no encrypt 

openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt
Thank You
Pradeep Singh - https://www.linkedin.com/in/dbxdev
0 Kudos