Snowflake

The Snowflake Database config is the way Ardent gains the ability to work with data in your Snowflake Database. It is designed to take in basic auth credentials and use that to automatically understand the data within your database and tables so you can perform operations on it.

Usage

To use the Snowflake integration with Ardent, you need to provide the necessary configuration details. Here's an example of how to set up the Snowflake config:

1. Find the Configs Section: Go to the configs section in the app

   

2. Add a Config: Click Add New Config

3. Select Config: Select the Snowflake config

4. Enter Values and Save Config: Configs will not save until you hit "save". Enter the necessary information for your config and hit Save
   • Account: Your Snowflake account identifier
   • User: Your Snowflake username
   • Password: Your Snowflake password
   • Warehouse: Your Snowflake warehouse name
   • Databases: Add any databases you want to work with

Connection Details

The Snowflake config requires:

• Account: Your Snowflake account identifier (e.g., xy12345.us-east-1)
• User: Your Snowflake username
• Password: Your Snowflake password
• Warehouse: The name of your compute warehouse
• Databases: The specific databases you want to work with

You can add multiple databases to a single configuration by using the "Add Database" button.

Note on Connection Configurations

Snowflake requires:

• A running Snowflake account
• Valid authentication credentials
• Proper database permissions
• An active warehouse
• Valid database names that exist in your Snowflake account
• Appropriate read/write permissions for the authenticated user
• Important: Make sure your warehouse is properly sized for your workload

For more information about Snowflake connection configuration, please refer to the Snowflake documentation.