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

saiV06 — Thu, 27 Feb 2025 19:38:09 GMT

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!

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

pradeep_singh — Wed, 25 Mar 2026 12:50:52 GMT

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

topic Re: Lakehouse Federation - Unable to connect to Snowflake using "PEM Private Key" in Administration & Architecture

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

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