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 the 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 three parts to setting up a Snowflake source.
The first step is input account identifier, compute warehouse, and the name of the database you want to extract data from.
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
Once you have input your account and credential information, you can test your connection on the Tables tab. Click “Connect” to continue. Note that we do not change error message coming from Snowflake.If you can successfully connect to Snowflake, you can now select the tables you want to extract data from.

​
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.