Connecting to Snowflake
This guide will walk you through how to connect to Snowflake. You may need to contact the administrator of your Snowflake account if you lack some of the credentials discussed below.
- Click
New Connection
in theManage Connections
modal in PopSQL - Create a
Nickname
for this connection (for your own internal reference) - For
Type
, choose Snowflake. - Your
Snowflake Account
is whatever comes beforesnowflakecomputing.com
when you sign into Snowflake directly. - For
Snowflake Warehouse
, in your Snowflake account, click Warehouses, and choose your desired warehouse under the column Warehouse Name. - To find your
Database
, in your Snowflake account, click Databases, and look in the Database column. - For
Username
andPassword
, enter the same credentials as you would enter when logging into your Snowflake account.
SSO, Okta, MFA/2FA
If you need MFA and/or Okta to sign into Snowflake, we support that on our Enterprise plan. Please get in touch with us if this applies to you.
The only thing your Snowflake administrator needs to do in the Snowflake UI is:
-- Create OAuth security integration
create or replace security integration popsql
type = oauth
enabled = true
oauth_client = custom
oauth_client_type = 'CONFIDENTIAL'
oauth_allow_non_tls_redirect_uri = true
oauth_redirect_uri = 'https://popsql.com/users/auth/snowflake_oauth2/callback'
oauth_issue_refresh_tokens = true
oauth_refresh_token_validity = 86400;
-- Get the client ID and secrets. Note the integration name must be uppercase here
select system$show_oauth_client_secrets('POPSQL');
-- Describe the security integration
-- In order to successfully use refresh tokens, ensure `PRE_AUTHORIZED_ROLES_LIST` is empty
describe security integration popsql;
If your Snowflake network policy has an IP whitelist, you'll also need to whitelist our static IPs: 23.20.131.72, 54.211.234.135
Spread the word
Tweet