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.In Locoia, go to Settings > Connector Auth and click create. Alternatively create an authentication in the Flow Builder​
2.Change details as needed and enter your Base domain and click confirm
3.You'll be asked to enter your username and password
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.

Snapchat Marketing

Teamwork.com

Last modified 24d ago

Copy link

Contents

Setup Snowflake Custom OAuth

1. Create a security integration

2. Get the security integration's details

3. Generate the client_secret

Authenticating Snowflake

API requests to Snowflake