> ## Documentation Index
> Fetch the complete documentation index at: https://docs.explo.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Snowflake

## Intro

Find out more about Snowflake [here](https://www.snowflake.com/).

## Default Warehouse for User

The Snowflake service user needs to have a default warehouse set. Check out [these Snowflake docs](https://docs.snowflake.com/en/user-guide/warehouses-overview#default-warehouse-for-users) 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](https://docs.snowflake.com/en/user-guide/admin-account-identifier#where-are-account-identifiers-used)

* **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](https://docs.snowflake.com/en/user-guide/key-pair-auth#configuring-key-pair-authentication) 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](https://www.snowflake.com/en/blog/blocking-single-factor-password-authentification/).  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](https://docs.snowflake.com/en/user-guide/programmatic-access-tokens)

## Allowlisting Explo's IPs

<Note>
  You may need to allowlist egress IPs for your
  [Connectivity Region](/data-sources/connecting-to-data-sources/connectivity-regions).
</Note>

## Questions?

Please reach out to the Explo team at
[support@explo.co](mailto:support@explo.co) if you have any questions.