> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Snowflake

> Snowflake services main features are separation of storage and compute, on-the-fly scalable compute, data sharing, data cloning, and third-party tools support in order to handle the demanding needs of growing enterprises.

## Creating a Snowflake connection

Use one of the following methods to make a connection:

* [Using an account](#using-an-account)
* [Using a data source name](#using-a-data-source-name)
* [Using a Key-Pair](#using-a-key-pair)

## Using an account

To create the connection you need:

* Access to your Snowflake organization
* Select which database and warehouse you wish to connect to

### Obtaining the credentials

Follow the [Snowflake Documentation](https://docs.snowflake.com/en/user-guide/admin-account-identifier.html) to obtain your account identifier.

### Creating your connection

1. In the Blink platform, navigate to the **Connections** page > **Add connection**. A New Connection dialog box opens displaying icons of external service providers available.

2. Select the **Snowflake** icon. A dialog box with name of the connection and connection methods appears.

3. (Optional) Edit the name of the connection. At a later stage you cannot edit the name.

4. Select **Account** as the method to create the connection.

5. Fill in the parameters:

   * The **Account Identifier**
   * **Username** of the user to use for authentication
   * **Password** of the user to use for authentication
   * Name of the **Database** you wish you operate on
   * The name of an active **Warehouse** to use to execute your requests

6. (Optional) Click **Test Connection** to test it.

7. Click **Create connection**. The new connection appears on the **Connections** page.

## Using a data source name

### Obtaining the credentials

An alternative type of authentication is a custom Data Source Name (DSN) for Blink.

View the [Go Snowflake Documentation](https://pkg.go.dev/github.com/snowflakedb/gosnowflake#hdr-Connection_String) on how to format the connection string.

### Creating your connection

1. In the Blink platform, navigate to the **Connections** page > **Add connection**. A New Connection dialog box opens displaying icons of external service providers available.
2. Select the **SnowFlake** icon. A dialog box with name of the connection and connection methods appears.
3. (Optional) Edit the name of the connection. At a later stage you cannot edit the name.
4. Select **DSN** as the method to create the connection.
5. Fill in the parameters:
   * The full **DSN** string to use for connection
6. (Optional) Click **Test Connection** to test it.
7. Click **Create connection**. The new connection appears on the **Connections** page.

## Using a Key-Pair

### Obtaining the credentials

Follow the [Snowflake Documentation](https://docs.snowflake.com/en/user-guide/key-pair-auth#configuring-key-pair-authentication) to obtain your keys.

### Creating your connection

1. In the Blink platform, navigate to the **Connections** page > **Add connection**. A New Connection dialog box opens displaying icons of external service providers available.

2. Select the **Snowflake** icon. A dialog box with name of the connection and connection methods appears.

3. (Optional) Edit the name of the connection. At a later stage you cannot edit the name.

4. Select **Key Pair** as the method to create the connection.

5. Fill in the parameters:

   * The **Account Identifier**
   * **Username** of the user to use for authentication
   * **Private Key** of the user to use for authentication
   * Name of the **Database** you wish you operate on
   * The name of an active **Warehouse** to use to execute your requests

6. (Optional) Click **Test Connection** to test it.

7. Click **Create connection**. The new connection appears on the **Connections** page.