Snowflake

Setup Snowflake Custom OAuth

Details about custom OAuth for Snowflake are described here.

1. Create a security integration

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.

2. Get the security integration's details

Run the below command to get all Oauth2 details:

desc security integration oauth_locoia;

oauth_locoia is the integration name. The result looks like:

3. Generate the client_secret

Run the below command:

select SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('OAUTH_LOCOIA');

The client_secret is be returned.

Authenticating Snowflake

1. In Locoia, go to Settings > Connector Auth and click create. Alternatively create an authentication directly in the Flow Builder

2. Enter your details as explained in the images below:

3. Sign in with your Snowflake credentials. Note that this user can't have the roles ACCOUNTADMINor SECURITYADMIN.

4. In the final step, you need to click Allow in order to grant access to the mentioned Snowflake entities:

API requests to Snowflake

The Snowflake API and its requests is described here.