> For the complete documentation index, see [llms.txt](https://docs.alkemi.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.alkemi.ai/documentation/getting-started/connect-your-data/connecting-snowflake.md).

# Connecting Snowflake

{% stepper %}
{% step %}

## Click +Add under integrations

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

<figure><img src="/files/ethzojAzRMXLlQWxzcat" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/gzHJJGoho2SmTehDAlw5" 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="/files/caFr4dWHbtYUjxUPDKJh" 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="/files/bthtMHldGoPbjKBDszlP" 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="/files/Raq8eQX1nR91y5SVd6Po" 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="/files/QEQsEtnGgXrPGq5xCvNB" 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 %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.alkemi.ai/documentation/getting-started/connect-your-data/connecting-snowflake.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
