Snowflake

This section describes how to create a connection to your Snowflake data warehouse

Snowflake is an S3-based data warehouse service hosted in the cloud. Auto-scaling, automatic failover, and other features simplify the deployment and management of your enterprise's data warehouse. For more information, see https://www.snowflake.com.

  • Read: Supported

  • Write: Supported

This connection type can be used to connect to Snowflake instances hosted in AWS or Azure.

Steps to Create a Snowflake Connection

  1. Login to the application

  2. In the left navigation bar, click the Connection icon

  3. Click the Create Connection button

  4. Click the Snowflake card

  5. Fill in the following information [* denotes required filled]

Property Name
Description
Example

Connection*

Snowflake (pre-populated)

Connection Name*

Provide a custom connection name

Snowflake - Prod

Connection Description

Provide a custom connection description (optional field)

Production Snowflake data

Account Name*

Snowflake account to use. Your account name might include your account, region and ither segment.

mycompany123.us-east-1

Warehouse*

The name of the warehouse to use when connected. The warehouse should be an existing warehouse for which the default role has privileges.

demo_warehouse

Stage

Not applicable

Connection String Options

Not applicable

Database*

Database in your snowflake instance

EMPLOYEE_DEMO

Database for stage

Not applicable

Credential Type*

Defaulted to Basic

Username*

User name

demo_account

Password*

Password

******

Last updated