Snowflake
Setup Snowflake Custom OAuth
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 domainand 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
Last modified 5mo ago