Locoia
Search…
Snowflake

Setup Snowflake Custom OAuth

Details about custom OAuth for Snowflake are described here.

1. Create a security integration

1
create security integration oauth_locoia
2
type = oauth
3
enabled = true
4
oauth_client = custom
5
oauth_client_type = 'CONFIDENTIAL'
6
oauth_redirect_uri = 'https://api.locoia.com/v1/oauth2/callback/snowflake'
7
oauth_issue_refresh_tokens = true
8
oauth_refresh_token_validity = 86400
9
;
Copied!
Further configuration options can be specified for the security integration if needed.
Only Snowflake account administrators (ACCOUNTADMIN role) or a role with the global CREATE INTEGRATION privilege can execute this SQL command.

2. Get the security integration's details

Run the below command:
1
desc security integration oauth_locoia;
Copied!
oauth_locoia is the integration name. The result looks like:

3. Generate the client_secret

Run the below command:
1
select SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('OAUTH_LOCOIA');
Copied!
The integration name needs to be in upper case letters.
The client_secret is be returned.

Authenticating Snowflake

  1. 1.
    In Locoia, go to Settings > Connector Auth and click create. Alternatively create an authentication in the Flow Builder
  2. 2.
    Change details as needed and enter your Base domain and click confirm
  3. 3.
    You'll be asked to enter your username and password
  4. 4.
    You'll see a screen like the below. Read the details and if you are ok, click "Allow"

API requests to Snowflake

The Snowflake API and its requests is described here.
Last modified 24d ago