# Connecting Snowflake

{% stepper %}
{% step %}

## Click +Add under integrations

Click the **Add** button and select Snowflake.

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2Ff1zJa8rPTuxBBhwT0cjJ%2F%2BAdd.png?alt=media&#x26;token=d21691c0-64ac-4693-a81a-91a8883f9a13" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2FBhasYJWSxAa1VBoE8mAQ%2FScreenshot%202025-08-14%20at%206.11.53%E2%80%AFPM.png?alt=media&#x26;token=0c38372f-454a-40a2-849f-3394eb260f25" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

## Input a Connection Name and your Snowflake Account ID

Input a name for your connection. Then In another tab, go to your account in Snowflake to obtain your Account ID.

To find your account ID, in Snowflake click your username in the lower left and navigate to **Account > View Account Details**.

Copy the **Account identifier** to your clipboard and paste into the **Account ID** field in the integration form in DataLab.

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2FNXvG12DEcchWOxaWbOEH%2FSnowflake01.png?alt=media&#x26;token=f53aa60e-1f7b-4280-94b5-5e15688afca4" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Create a new user for Alkemi in Snowflake (recommended)

For added security, it's recommended that you create a service user in Snowflake for your DataLab connection. In the form we provide a guide with SQL that you can run in a Snowflake workspace to create the user and roles. Expand the guide to view the generated SQL.

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2FHedRSd3rPiHozk7xFixx%2FScreenshot%202025-10-15%20at%2011.21.21%E2%80%AFAM.png?alt=media&#x26;token=6ee2b949-7f51-4ce4-8b81-e5741584a1f2" alt=""><figcaption></figcaption></figure>

In Snowflake, navigate to **Projects > Workspaces** and add a new SQL file.

Copy and paste the SQL from the guide into this new file. This includes a unique public key that DataLab has generated for this connection. Replace database\_name and schema\_name in the SQL with your database and schema details. Now click the **Run** button to create the user.

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2F1jVxPvQqAe8wusUbleaR%2Fsnowflake_workspace.png?alt=media&#x26;token=56ecb83c-14e5-4c93-80e2-8dc84a3713af" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Enter your Snowflake Username, Role, and Warehouse

Make sure these match what you created in Step #3.

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2FgDymQewc2CyvkqrWt2Ut%2Fsnowflake_user-role-warehouse.png?alt=media&#x26;token=80d2ef1b-14c8-4545-9132-6908d184435a" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Test and Save your connection

Alkemi will let you know if it encounters any connection issues.
{% endstep %}

{% step %}

### Start creating data products!

Begin creating data products in DataLab for text-to-SQL on your Snowflake data, and enable MCP connections to your data in chat clients such as Claude, Cursor, and ChatGPT. For more details, see "Creating a Data Product."
{% endstep %}
{% endstepper %}