OAC-Snowflake Key Pair authentication

User_SK2UI

Currently OAC is connecting to Snowflake using service account and password . But our security team restricting username and password method of authentication . They want all applications to use key pair authentication to connect to snowflake . But OAC don't support that feature now .

We would like to request that enhancement as to be compliant with security and compliance policies .

User_MXOZB

This is a very high priority requirement. Due to recent Snowflake data breaches which were all originated from mishandled user credentials, our Information security is mandating us to use key-pair based authentication for all Snowflake integrations. We enabled key-based auth on all our integrations except Oracle.

Oracle uses Snowflake JDBC driver behind the scene and Snowflake JDBC driver support key based auth. But unfortunately Oracle connection UI is not providing an option to switch from password to key-based. This enhancement should allow us to punch in a username, passphrase(masked) and upload a private key. Please elevate the priority of this feature request.

REPSRV Mal

Curremtly we connect to snowflake from our OAC using password based authentication. Due to security reasons, We wanted to use RSA key based authentication to connect to Snowflake.

Can you please expedite this enhancement?

Please let us know if you know by when you may able to release key based authentication feature?

Doug Ross

Any update on the availability of passphrase credentials for OAC to Snowflake? We have multiple customers who will need this when Snowflake transitions away from password based service accounts.

User_BM327

Any update ?
We are facing same issue with Key/Pair auth

User_6LBM1

@Alan Lee - Oracle-Oracle - Do we have any roadmap planned for Key Pair authentication for Snowflake? Password authentication will be deprecated by Nov 2025 as per release from Snowflake.

Snowflake Community

Doug Ross

Agree. This is a significant issue for my customer and it is crucial that Oracle makes a statement on when the key pair capability will be available for Snowflake connections. Customer is on OAS and will need this for the RPD connection pools.

Alan Lee - Oracle

Yes, key pair auth for Snowflake is on the plan. No target timeframe at this time.

User_MXOZB

Snowflake will deprecate password based authentication soon. Oracle has to prioritize this request to avod any impact to ongoing customer integrations and aiding platform security.

https://community.snowflake.com/s/article/FAQ-Snowflake-to-block-password-only-logins#:~:text=As%20part%20of%20our%20ongoing,approach%20to%20navigate%20this%20transition.