> For the complete documentation index, see [llms.txt](https://docs.kognitos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.kognitos.com/guides/platform/integrations/snowflake.md).

# Snowflake

Overview of the Snowflake integration.

{% hint style="info" %}
The following documentation is for **Snowflake v3.4.1**.
{% endhint %}

## 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.

## Setup

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

* **Snowflake**

### Steps

Follow these steps to connect the integration in Kognitos:

{% stepper %}
{% step %}

#### Navigate

Using the left navigation menu, go to **Integrations** → **Explore Integrations**.
{% endstep %}

{% step %}

#### Find

Search for the integration and click on it.
{% endstep %}

{% step %}

#### Connect

Click on <kbd>**Connect**</kbd> to add a connection to the integration.
{% endstep %}

{% step %}

#### Configure

Add a name for the connection. You'll be prompted for [**authentication**](#authentication) details if needed. Then, click on <kbd>**Connect**</kbd>.
{% endstep %}
{% endstepper %}

## 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 and Password

Connect to a Snowflake database using the provided connection parameters.

| Label      | Description                                           | Type        |
| ---------- | ----------------------------------------------------- | ----------- |
| Account ID | Id of the Snowflake account (e.g. "ABCDEFG-ABC12345") | `text`      |
| Username   | Username of the Snowflake account                     | `text`      |
| Password   | Password of the Snowflake account                     | `sensitive` |

### Connect using Account ID, Username and Private Key

Connect to a Snowflake database using key pair authentication.

| Label       | Description                                           | Type        |
| ----------- | ----------------------------------------------------- | ----------- |
| Account ID  | Id of the Snowflake account (e.g. "ABCDEFG-ABC12345") | `text`      |
| Username    | Username of the Snowflake account                     | `text`      |
| Private Key | PEM-encoded private key (must be unencrypted)         | `sensitive` |

### Connect using Account ID, Username, Private Key and Private Key Passphrase

Connect to a Snowflake database using key pair authentication with a passphrase-protected key.

| Label                  | Description                                           | Type        |
| ---------------------- | ----------------------------------------------------- | ----------- |
| Account ID             | Id of the Snowflake account (e.g. "ABCDEFG-ABC12345") | `text`      |
| Username               | Username of the Snowflake account                     | `text`      |
| Private Key            | PEM-encoded private key (passphrase-protected)        | `sensitive` |
| Private Key Passphrase | Passphrase for the private key                        | `sensitive` |

### Connect using Account ID, Username and Token

Connect to a Snowflake database using a Programmatic Access Token.

| Label      | Description                                           | Type        |
| ---------- | ----------------------------------------------------- | ----------- |
| Account ID | Id of the Snowflake account (e.g. "ABCDEFG-ABC12345") | `text`      |
| Username   | Username of the Snowflake account                     | `text`      |
| Token      | Programmatic Access Token                             | `sensitive` |