Snowflake

Procedures and concepts for the Snowflake integration.

The following documentation is for Snowflake v2.0.1 (BDK).

Overview

Snowflake is a cloud-based data platform that provides data warehousing, data lakes, data engineering, and data science capabilities. This integration enables automated data loading, query execution, data transformation, and analytics workflows within Snowflake's cloud architecture.

Prerequisites

1. Required Books

The following Book(s) need to be added to your agent so it can learn and understand the automation procedures defined within them:

• Snowflake

How to Add the Book(s)

1. Go to Books → All Books.

2. Search for the name of the book and click on it.

3. Click on Install or Add Connection to add the book to your agent.

4. If adding a connection, you'll be prompted for connectivity details.

Connectivity

This section outlines the available methods for connecting to the Book, along with the required configuration details for each.

Connect using Account ID, Username, Password, Database Name, Schema, Warehouse and Role

Connect to a Snowflake database using the provided connection parameters.

Label	Description	Type
Account ID	Id of the Snowflake account	text
Username	Username of the Snowflake account	text
Password	Password of the Snowflake account	sensitive
Database Name	Database Name	text
Schema	Schema	text
Warehouse	Warehouse of the database	text
Role	Role of the db's user	text