Intro
Find out more about Snowflake here.Default Warehouse for User
The Snowflake service user needs to have a default warehouse set. Check out these Snowflake docs to see how to set a default warehouse.Necessary Credentials
-
Username
- This is your service user’s username
- Example: explo_user
-
Account
- Snowflake account identifiers
- Find out more here
-
Database
- Name of the database within Snowflake
- Example: snowflake_sample_data
Authentication Options
-
Private Key (Recommended)
- You’ll pass in your RSA private key to Explo to use in authenticating with Snowflake. See Snowflake’s documentation for help creating and setting up an unencrypted private key.
-
Password (Deprecated) / PAT
- Snowflake has deprecated single-factor password authentication and will block it by November 2025. It is highly recommended to setup Private Key or PAT authentication instead.
- You can also use a Programmatic Access Token (PAT) instead of a password to authenticate with Snowflake. See Snowflake’s documentation
Allowlisting Explo’s IPs
You may need to allowlist egress IPs for your
Connectivity Region.