Snowflake

To connect your Snowflake data warehouse to Neo, you’ll need a few essential details like your account name, database, and authentication credentials.

Getting Started

To connect to Snowflake, you’ll need to fill in:

  • Your account, warehouse, database, and schema

  • An authentication method:

    • Standard (Username & Password)

    • Key Pair Authentication (for enhanced security)

Connection Details

Here’s what each field means and how to fill it out:

1. Name

Give this source a unique name so you can easily identify it later.

Example:

  • snowflake-prod

  • marketing-snowflake

  • team-analytics-wh

This name must be unique across all sources you configure.

2. Account

Provide your Snowflake account identifier. This usually looks like:

your_org-account_name

or

xyz12345.us-east-1

Check your Snowflake URL—it’s usually the part before .snowflakecomputing.com.

3. Warehouse

This is the compute resource that runs your queries.

Specify the warehouse you want to use for this connection.

Example: COMPUTE_WH, ANALYTICS_WH

4. Database

Enter the database name where your data resides.

Example: sales_data, customer_360, internal_metrics

Choose Your Authentication Method

You can authenticate using:

  • Standard Authentication (username & password)

  • Key Pair Authentication (for secure, key-based login)

Option 1: Standard Authentication

This is the simplest method if you have a username/password for your Snowflake account.

You’ll need:

Username:

Your Snowflake login name.

Example: readonly_user

Password:

The associated password.

This field is securely hidden in the UI.

Use this if you already log in manually to Snowflake using a username and password.

Option 2: Key Pair Authentication

This method is recommended for automated, production environments.

You’ll need:

User:

Your Snowflake username.

Same as in Standard Auth.

Private Key:

A private key in PKCS#8 PEM format.

Formatting Requirements:

  • The key must be in PEM format (not raw base64 or DER).

  • It should start with -----BEGIN PRIVATE KEY----- and end with -----END PRIVATE KEY-----.

  • Ensure the key is in PKCS#8 format (not PKCS#1).

  • The key should be unencrypted, or if encrypted, provide the correct passphrase.

Example:

-----BEGIN PRIVATE KEY----- MIIEv…​your_key…​AB -----END PRIVATE KEY-----

Private Key Passphrase (optional):

If your private key is encrypted, enter the exact passphrase here.

If your key is unencrypted, leave this blank.

The private key will be automatically converted to the format expected by Snowflake during connection, so just ensure you copy-paste the PEM content correctly (with all line breaks).

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.