Skip to main content
You need to make sure the Less IPs are whitelisted in your Snowflake account. You can find the IPs here.You can also choose to use PAT (programmatic access tokens) instead of username and password.
You can find most of the information you need from Snowflake here. You also need a compute warehouse which you can find under Compute in the left sidebar of Snowflake. Lastly, you need the name of database you want to extract data from.

​
Password or Service Account Setup

There are two parts to setting up a Snowflake destination.
The first step is input account identifier, compute warehouse, and the name of the database you want to send data into.
Step two is to input a role (see the GIF above to find it in Snowflake). Secondly, you need to select your authentication type. By default, you can only choose “Password”. You can enable OAuth 2.0 authentication as well (see below).Input your username and password if you choose “Password” authentication. Alternatively, click “Authenticate with Snowflake” if you have enabled OAuth 2.0 authentication.
We’re working on enabling Service Account authentication
Finally, we recommend that you test the connection before continuing to ensure that the connection is successful.

​
OAuth 2.0 Authentication

Admins and Super Admins can enable the users in your Less workspace to connect to Snowflake with OAuth 2.0 authentication. To do so, you need to first create a custom OAuth 2.0 application in Snowflake. You can find the instructions here.
This is rather complex. Reach out to us if you want our help with setting up Snowflake OAuth 2.0 authentication.
Once you’ve created the OAuth 2.0 application in Snowflake, navigate Settings -> Other and click “Connect” in the Snowflake OAuth settings section. There you’ll need to input the following:
  • Client ID: The Client ID of the OAuth 2.0 application you created in Snowflake.
  • Client Secret: The Client Secret of the OAuth 2.0 application you created in Snowflake.
  • Authorization URL: The Authorization URL of the OAuth 2.0 application you created in Snowflake.
  • Token URL: The Token URL of the OAuth 2.0 application you created in Snowflake.
Click “Save Settings” to continue. Once you’ve saved the OAuth 2.0 application, you can now connect to Snowflake with OAuth 2.0 authentication when setting up a Snowflake source.