Reauthorising Snowflake OAuth Data Bridge Connection
Peak offers its customers the flexibility to choose their own Snowflake data warehouse or a Peak-managed one. Peak maintains and manages the warehouse for the customer in case the customer opts for a Peak-managed data warehouse. Peak uses the OAuth mechanism for authorization purposes for the warehouse.
Customers can choose between basic auth and OAuth to provide access to their Snowflake data warehouse. This article will guide the user through re-authorizing the Snowflake OAuth connection.
Why is re-authorization required?
On authorizing the Snowflake connection to allow Peak to query Snowflake, Peak is provided with a refresh token that has validity attached to it. The default validity is 90 days. It can be extended up to 1 year. You can check the refresh token validity of the security integration by describing the security integration. The customer needs to request Snowflake to get this extended. You can find more information here.
If the refresh token expires, the Peak platform won't be able to generate a new access token to access the Snowflake data warehouse. All operations on the platform that require the data warehouse will stop working.
There is no automated way to get a new refresh token other than to authorize the connection again by logging in to Snowflake.
How to re-authorize the connection?
- Navigate to Data Bridge under the Manage section.
- Click Re-Authorize on the data warehouse panel.
- This will redirect you to the Snowflake login page.
Please ensure that you log in with the user who has access to the role that you provided during the data warehouse setup. You can check the role by clicking the expand icon on the data warehouse panel.
- After the Snowflake login, you will be redirected back to the Peak platform. The success or failure of the request will be visible on the platform.