First, create a new Worksheet to be able to execute queries. Next, run the below query:
create security integration oauth_locoia
type = oauth
enabled = true
oauth_client = custom
oauth_client_type = 'CONFIDENTIAL'
oauth_redirect_uri = 'https://api.locoia.com/v1/oauth2/callback/snowflake'
oauth_issue_refresh_tokens = true
oauth_refresh_token_validity = 86400
Further configuration options can be specified for the security integration if needed.
Run the below command to get all Oauth2 details:
desc security integration oauth_locoia;
oauth_locoiais the integration name. The result looks like:
Run the below command:
The client_secret is be returned.
Names and locator as seen in Snowflake (minimum role to see accounts:
Entering the corresponding values in the Connector Auth
3. Sign in with your Snowflake credentials. Note that this user can't have the roles
Login with your Snowflake user
4. In the final step, you need to click Allow in order to grant access to the mentioned Snowflake entities: