Snowflake

Overview of the Snowflake integration.

The following documentation is for Snowflake v2.1.0.

Overview

Enables connecting to and querying Snowflake databases.

The Snowflake integration supports discovery. Once connected, you can browse available services and entities directly from Kognitos, then enable the specific actions your automations need. See Custom Actions for setup instructions.

Setup

The following integrations need to be connected to your Kognitos workspace:

• Snowflake

Steps

Follow these steps to connect the integration in Kognitos:

1

Navigate

Using the left navigation menu, go to Integrations → Explore Integrations.

2

Find

Search for the integration and click on it.

3

Connect

Click on Connect to add a connection to the integration.

4

Configure

Add a name for the connection. You'll be prompted for authentication details if needed. Then, click on Connect.

Discovering Actions

After connecting, you can discover and enable the specific services and entities available in your system:

1

Open the connection menu

Navigate to Integrations, find your Snowflake connection, and click the three-dot menu ⋯ next to the connection name. Select Configure Actions.

2

Browse and enable services

Browse or search for the services you need. Toggle them on to enable them in your workspace.

3

Save and wait

Click Save to apply your configuration. Allow 1-2 minutes for Kognitos to complete the discovery process. Once finished, the enabled actions become available in your drafts and automations.

Authentication

Use one of the following authentication methods to connect this integration in Kognitos. Each method has its own configuration requirements.

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