Snowflake

Connect to Snowflake to query and analyze your cloud data warehouse. Supports tables with geography columns for spatial analysis.

Connect to Snowflake

1. Click Add data in the Layers panel
2. Go to the Connections tab
3. Select Snowflake
4. Fill in the connection parameters
5. Click Create Connection

Connection Parameters

Find your account identifier in Snowsight under Admin → Accounts. The Account URL format (https://ORGNAME-ACCOUNTNAME.snowflakecomputing.com) is also accepted.

Authentication Methods

Choose one of four authentication methods:

Access Token (Recommended)

Use a programmatic access token (PAT) for secure authentication without storing passwords.

1. Go to Snowsight → User menu → My Profile
2. Click Access Tokens → Generate Token
3. Copy and paste the token into Atlas

OAuth

Use Snowflake's browser-based OAuth flow. This is the recommended alternative when your organization's network policy blocks programmatic access tokens.

OAuth requires a Security Integration configured by a Snowflake ACCOUNTADMIN.

Step 1 — Create a Security Integration in Snowflake:

When you select OAuth in Atlas, the connection form displays the exact CREATE SECURITY INTEGRATION SQL to run, with the Atlas redirect URI pre-filled. Copy it and run it in Snowflake as an ACCOUNTADMIN or SECURITYADMIN.

Step 2 — Authorize in Atlas:

1. Select OAuth as the authentication method
2. Enter your Account Identifier or paste the full Account URL
3. Select the Role to use — note that ACCOUNTADMIN and SECURITYADMIN are blocked by Snowflake's OAuth policy; use a standard role
4. Click Authorize with Snowflake to complete the OAuth handshake in a popup window

Atlas stores the refresh token and re-authorizes automatically. No passwords or private keys are stored.

Private Key

Use RSA key-pair authentication for enhanced security.

1. Generate a key pair in PKCS#8 format:

openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub

2. Register the public key with your Snowflake user
3. Upload the .p8 file or paste the PEM key in Atlas

Password

Standard username and password authentication. Less secure than token or key-based methods.

Working with Data

After connecting, browse available schemas and tables. Select the data you want to import and click Add to Project. Tables with Snowflake Geography columns import as vector layers.

Network Policies

If your Snowflake account uses network policies, add these Atlas IP addresses to your allowed list:

116.16.129.130
251.20.23.178
313.50.71.210
451.21.188.73

Troubleshooting