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.
New Connectionin the
Manage Connectionsmodal in PopSQL
Nicknamefor this connection (for your own internal reference)
Snowflake Accountis whatever comes before
snowflakecomputing.comwhen you sign into Snowflake directly.
Snowflake Warehouse, in your Snowflake account, click Warehouses, and choose your desired warehouse under the column Warehouse Name.
Database, in your Snowflake account, click Databases, and look in the Database column.
Password, enter the same credentials as you would enter when logging into your Snowflake account.
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 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');