# Access data in Snowflake

In order to make the Data Observatory subscriptions accessible in your Snowflake account, first of all CARTO needs to create and register your subscriptions in your CARTO account. Once this first step has been done, Admin users of your CARTO organization will be able to see the list of active subscriptions in the [Data Observatory section](/carto-user-manual/settings/data-observatory.md) in Settings.

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

Once your subscriptions have been created, the CARTO team will proceed with the data transfers so to make the data accessible directly on your Snowflake account. **Please contact your CARTO representative** if you need to start this process on demand (e.g. public data subscriptions).

In order to make your subscriptions available in your Snowflake account, CARTO leverages the native [private sharing](https://other-docs.snowflake.com/en/collaboration/consumer-listings-access#label-access-private-listing) mechanisms of Snowflake.

CARTO will create and maintain a listing privately shared with your Snowflake account containing the data from all your Data Observatory subscriptions. To be able to create such private share we will need to receive the following information regarding your Snowflake account:

* Account ID
* Organization ID
* Cloud
* Region

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXc9wkPQ8C3mluH9efxDct3rIwm8G82rPTz_TacXeBqzcnw1Bh6f0dmImCeYKLv6OQJWUZYZbT4M-suIC1p0SthDouOCk75v_yAgnB0AWrgG9UJLoWvkyLqQf2i-GhN15IB-ga5MGw?key=lIbabCTzaWzidWrERiiPXbeW" alt=""><figcaption></figcaption></figure>

Once the listing has been shared, users in your Snowflake account with access to Data Products (e.g. Account Admins) will receive an email notification stating that a data product is ready on the Snowflake account.

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

The data will be ready in the private share a bit later from the time that share is created and you receive the e-mail notification. Once all the data has been transferred, the CARTO team will inform you so you can proceed with the following steps.

On your Snowflake account, navigate to the **Data Products** section and then select **Private Sharing**. In that section you will find the different shares that have been shared with you. There you will find the share detailed on the e-mail notification.

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

Access the private share and then click on **"Get"**. You will be prompted to complete your profile to get data products (if you haven't done it already).

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

Then, you will be asked to provide a Database name and which roles in addition to ACCOUNTADMIN should be able to access that database. Then click on **"Get"**.

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

After a few seconds the new database will be created and the data from your subscriptions will be ready to use!.

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

<figure><img src="/files/2Bbwr00UiAxg5KSuIf2M" alt=""><figcaption></figcaption></figure>

### Access the data from your data warehouse connection in CARTO

Once the transfer has been completed, you will be able to explore your subscription directly from your data warehouse in the [Data Explorer](/carto-user-manual/data-explorer.md):

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

To learn more about Snowflake connections in CARTO please access [this section](/carto-user-manual/connections/snowflake.md). For map performance considerations please read [these recommendations](/carto-user-manual/maps/performance-considerations.md).

{% hint style="info" %}
Remember to **grant privileges** on the database to any Snowflake roles that will need to access and use the data.
{% endhint %}


---

# Agent Instructions: 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.carto.com/carto-user-manual/data-observatory/accessing-your-subscriptions-from-your-data-warehouse/access-data-in-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.