Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAC-Snowflake Key Pair authentication

Delivered
520
Views
18
Comments
2»

Comments

  • User_1CVAV
    User_1CVAV Rank 1 - Community Starter

    Urgent Request:

    Key Pair Authentication for Snowflake Integration Snowflake will soon deprecate password-based authentication. To avoid any impact on ongoing customer integrations and enhance platform security, Oracle must prioritize this request.
    Timeline: Aug. 2025 - Oct. 2025: Mandatory MFA for all new human users.

    Currently, OAC connects to Snowflake using a service account and password.

    However, the security team is enforcing restrictions on username and password authentication methods, mandating that all applications utilize key-pair authentication for connecting to Snowflake.

    Unfortunately, OAC is the only tool that does not support this feature.

    This requirement is of the highest priority.

    Please elevate the priority of this feature request considering the Snowflake announcement of enforcing key-pair authentication.

  • User_DHLHM
    User_DHLHM Rank 2 - Community Beginner

    Currently OAC is connecting to Snowflake using service account and password . But our security team restricting username and password method of authentication by November 2025 . 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 . Could you please let us know any plan and the time of this enhancement availability.

    Without this enhancement , our plateform is going to loose the connection to snowflake database as its the only end-user database to our oracle reports. Which will impact our customers and us.

  • Alan Lee - Oracle-Oracle
    Alan Lee - Oracle-Oracle Mod

    Key-pair authentication is planned for Sep OAC update and we also plan on a solution for OAS at that time as well. @Doug Ross Can you share details on how your OAS customer is connecting to Snowflake via RPD so we can confirm the solution for that particular use case? i.e. are they using ODBC DSN. Please feel free to reach via email to discuss.

  • Doug Ross
    Doug Ross Rank 6 - Analytics Lead

    This is great news!

    Call Interface: JDBC (Direct Driver)

    Connection string:

    jdbc:snowflake://xxxxxxxx.us-east-1.snowflakecomputing.com?db=XXX_P_YYY_DB&warehouse=P_XXX_YYY_TST_WH&schema=REPORTING&role=FR_P_XXX_YYY_READER

    Shared Logon checked

    Username is a service account for the snowflake database

  • User_DHLHM
    User_DHLHM Rank 2 - Community Beginner

    Hi Team,

    Could you please let us know date for the September release for the OAC -snowflake keypair authentication update?

  • Vijay Babu
    Vijay Babu Rank 1 - Community Starter

    Hi Team,

    Is there any update on enabling OAC RPD accepting Key Pair Authentication?

  • Paolo Piccioni-Oracle
    Paolo Piccioni-Oracle Rank 1 - Community Starter

    This is now addressed in the Sep 2025 release of OAC:

    https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-snowflake-data-warehouse.html#GUID-BA2D5623-D18F-47DD-B9B1-FF23C3DFDDAA

  • User_1NBVE
    User_1NBVE Rank 1 - Community Starter

    @Alan Lee - Oracle-Oracle - It looks like Snowflake will begin enforcing "key pair authentication" for service users starting in November 2025. Do we know if OAC Sept release is going to have an update to support this? Appreciate your insights on this. Thank you!