You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We currently have a server that maintains a connection pool to various DataWarehouses and we want to enable OAuth connections for Snowflake, but I'm struggling to figure out how to make it work with HikariCP.
Snowflake access tokens last for 10 minutes, and we'll have an external client that handles the OAuth flow and passes the Access Token back to the server when making requests. This client will handle token refreshes, so when the access token changes it'll simply pass along the new access token for subsequent requests. Here's some docs on the general flow: https://community.snowflake.com/s/article/HOW-TO-OAUTH-TOKEN-GENERATION-USING-SNOWFLAKE-CUSTOM-OAUTH
My initial thought is that I can:
Set maxLifetime to 10 minutes
On each request, call dataSource.addDataSourceProperty("token", accessToken)
Would this be enough to force Hikari to pick up the changed property when re-creating a connection?
Is there some other recommended alternative?
The text was updated successfully, but these errors were encountered:
We currently have a server that maintains a connection pool to various DataWarehouses and we want to enable OAuth connections for Snowflake, but I'm struggling to figure out how to make it work with HikariCP.
Snowflake access tokens last for 10 minutes, and we'll have an external client that handles the OAuth flow and passes the Access Token back to the server when making requests. This client will handle token refreshes, so when the access token changes it'll simply pass along the new access token for subsequent requests. Here's some docs on the general flow: https://community.snowflake.com/s/article/HOW-TO-OAUTH-TOKEN-GENERATION-USING-SNOWFLAKE-CUSTOM-OAUTH
My initial thought is that I can:
maxLifetime
to 10 minutesdataSource.addDataSourceProperty("token", accessToken)
Would this be enough to force Hikari to pick up the changed property when re-creating a connection?
Is there some other recommended alternative?
The text was updated successfully, but these errors were encountered: