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 OAuth mechanism for authorisation purpose 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-authorising the Snowflake OAuth connection.
Contents
Why is re-authorization required?
On authorising 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, 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 authorise the connection again by logging in to Snowflake.
How to re-authorize the connection?
- Navigate to Data Bridge under the Manage section.
- Click Re-Authorise on the data warehouse panel.
- This will redirect you to the Snowflake login page.
Please ensure that you login 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.