Skip to main content

Snowflake Database Connector

Snowflake is a relational database offering robust data storage, management, and querying features tailored for different scales and use cases.

info

For the common steps on adding connectors in Unstract, see Working with Connectors.

Getting started with Snowflake​

  1. Create a Snowflake account
  2. Follow the steps to create a Database img Snowflake Database Connector Configuration
  3. Get or Create the Warehouse img Snowflake Database Connector Configuration
  4. Get the Role img Snowflake Database Connector Configuration
  5. Get the account identifier img Snowflake Database Connector Configuration

Adding Snowflake Connector in Unstract​

When configuring the Snowflake connector, you'll need to provide the following connection details:

Required Configuration Fields​

  • Name of the connector: Enter a descriptive name for your Snowflake connector
  • User: Enter your Snowflake username
  • Password: Enter your Snowflake password
  • Account: Enter your Snowflake account identifier (without the snowflakecomputing.com domain)
  • Database: Enter the database name
  • Schema: Enter the default schema (e.g., PUBLIC)
  • Warehouse: Enter the data warehouse name
  • Role: Enter the role (e.g., SYSADMIN)

Snowflake Connector Filled Form

Account Identifier​

The account identifier is a unique identifier for your Snowflake account. Do not include the snowflakecomputing.com domain name as part of your account identifier. Snowflake automatically appends the domain name to your account identifier to create the required connection.

Example account identifier format: xy12345.us-east-1