# CARTO Data Warehouse

Every CARTO organization comes provisioned with an active data warehouse connection that is created by default.

This connection will grant you access to some resources, in terms of cloud storage and cloud computing, that are provided by CARTO. This default connection will help you get started with our platform, and it will also give you access to some demo datasets so you can start using our platform from the very beginning. It will also enable you to have access to spatial datasets from CARTO’s Data Observatory without the need of connecting your own data warehouse to get access to cloud resources.

<figure><img src="https://3029946802-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FybPdpmLltPkzGFvz7m8A%2Fuploads%2Fgit-blob-1f0f6bf93911a343aab626269e2e13e161b63b53%2Fthe_connections_the_cartodw.png?alt=media&#x26;token=97918b13-dc11-4c73-a1ca-2e7a57383a51" alt=""><figcaption></figcaption></figure>

## Limits <a href="#limits" id="limits"></a>

The `CARTO Data Warehouse` connection is limited to a certain amount of computing per day. You can find this limit in the `CARTO Data Warehouse` connection’s card. These limits depend on whether your organization has purchased the CARTO Data Warehouse Add-on in your subscription plan.

## Structure

For simplicity, the CARTO Data Warehouse uses the same structure and naming as a Google BigQuery connection: projects, datasets and tables.

Inside the CARTO Data Warehouse you'll find two primary datasets, available to all editors:

* [**Organization Data**](#carto-demo-data) (`organization data`): the data managed by you and your teammates.
* [**CARTO Demo Data**](#carto-demo-data-1) (`demo data`): these are tables and tilesets curated by CARTO

<figure><img src="https://3029946802-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FybPdpmLltPkzGFvz7m8A%2Fuploads%2Fgit-blob-3d7414b55f388fbcedf524cf13a5eca9f25d1700%2FScreenshot%202023-01-26%20at%2011.42.54.png?alt=media" alt=""><figcaption></figcaption></figure>

## Organization Data <a href="#carto-demo-data" id="carto-demo-data"></a>

For the data that users in the organization will manage, there are two available datasets: private and shared.

### **Private**

<figure><img src="https://3029946802-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FybPdpmLltPkzGFvz7m8A%2Fuploads%2Fgit-blob-a813ab83138e24beba62c4ed240ea435ee40d36e%2FScreenshot%202023-01-26%20at%2011.45.15.png?alt=media" alt=""><figcaption></figcaption></figure>

The private dataset is a unique dataset for each user, and all the tables and tilesets in this folder will **only be available to that user**. Private datasets have a unique qualified name that identifies the user, extracted from their email.

For example, if a user with an email `johndoe@acme.com` and a table called `example_data` wants to use private data in a [Custom Query (SQL)](https://docs.carto.com/maps/data-sources#add-source-from-a-custom-query), they will use a qualified name similar to:

> carto-dw-ac-IDxxxxxx.private\_johndoe\_IDxxxxxx.example\_data

There are some particularities when using private data:

* Maps using private data can still be shared and made public without any issue
* Maps can still be duplicated and made collaborative, but your teammates won't be able to view the data in your private dataset.

{% hint style="info" %}
**If an editor user is deleted or downgraded to viewer**, their private dataset will be transferred to the admin, who will see the full qualified name in their Data Explorer (eg: *private\_johndoe\_IDxxxxxx*)

If the viewer is promoted to editor again, they will recover access to their private data but the admin will still retain privileges over that dataset. If this is an issue, re-create the user or contact our [Support Team](https://docs.carto.com/faqs/support-packages)
{% endhint %}

### **Shared**

<figure><img src="https://3029946802-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FybPdpmLltPkzGFvz7m8A%2Fuploads%2Fgit-blob-9cb71cc3134e3fa023ffcfcb49da291822edfc1a%2FScreenshot%202023-01-26%20at%2011.44.21.png?alt=media" alt=""><figcaption></figcaption></figure>

The shared dataset is the same for every user inside the organization, and all the tables and tilesets in this folder will be available for all users.

## Data Observatory (US)

Inside the CARTO Data Warehouse > Organization Data you will find the `Data Observatory (US)` dataset. This dataset will contain all the **samples and subscriptions** that you've subscribed to from the [CARTO Data Observatory](https://docs.carto.com/carto-user-manual/data-observatory).

<figure><img src="https://3029946802-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FybPdpmLltPkzGFvz7m8A%2Fuploads%2Fgit-blob-22d1259653c0f6a6807735269b7881c06689fb6c%2FScreenshot%202025-06-24%20at%2018.18.08.png?alt=media" alt=""><figcaption></figcaption></figure>

## CARTO Demo Data <a href="#carto-demo-data" id="carto-demo-data"></a>

The `CARTO Data Warehouse` connection grants access to a set of demo tables and tilesets that can be used to start creating maps and exploring the tools from the very beginning. They’re available and ready to be used in the Data Explorer.

Additionally, if your onboarding experience was customized, you may get additional demo data for Retail, CPG or Out-of-home use cases.

<figure><img src="https://3029946802-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FybPdpmLltPkzGFvz7m8A%2Fuploads%2Fgit-blob-68672ac94e4b8e5ab9534e23dea7c2258668bedd%2FScreenshot%202023-01-26%20at%2011.46.12.png?alt=media" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
If your CARTO organization has been [provisioned on a cloud region](https://docs.carto.com/carto-user-manual/overview/carto-cloud-regions) outside the US (e.g., Europe-West, Asia-Northeast), you will find available an additional dataset called `shared-us` in your CARTO Data Warehouse connection. With the tables stored in `shared-us` you will be able to access certain functionalities, such as creating tilesets and performing data enrichment with Data Observatory subscriptions, that are only available at the moment for data tables stored in the US multi-region. In case of questions, please contact <support@carto.com>.
{% endhint %}

## Accessing the console

Technically speaking, the CARTO Data Warehouse is a fully-managed Google BigQuery project for the organization, where users in the organization can upload and analyze geospatial data as if they were connecting their own data warehouse. To complete the experience of this managed data warehouse, we give users the possibility of **directly accessing the SQL console**, to run their own queries there.

In order to get access to the console of the CARTO Data Warehouse, just provide a valid **Google Account:**

<figure><img src="https://3029946802-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FybPdpmLltPkzGFvz7m8A%2Fuploads%2Fgit-blob-5a0e258352bc55d6f8b3f48581ea6aabc9f69cf2%2FScreenshot%202023-04-26%20at%2017.46.38.png?alt=media" alt=""><figcaption><p>Please note that if you use Google to login, we will use that same account and you won't need this step</p></figcaption></figure>

Once the process is finished, the interface will change and it will display a shortcut to access the CARTO Data Warehouse console:

<figure><img src="https://3029946802-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FybPdpmLltPkzGFvz7m8A%2Fuploads%2Fgit-blob-0550a8870943a07405381835cdc631b154da8152%2FScreenshot%202023-04-26%20at%2018.00.55.png?alt=media" alt=""><figcaption></figcaption></figure>

At this point, we have granted your Google account permissions to access the console, plus access to the [**Analytics Toolbox for BigQuery**](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery), so you can run our functions directly in the console. If you click on *"Access console"* you'll be redirected to the Google BigQuery console, where you will have the same level of access than in the CARTO Data Explorer. You will likely see:

* Your [private dataset](#private-private)
* Your [shared dataset](#shared-shared)
* Your temporal [Workflows](https://docs.carto.com/carto-user-manual/workflows) dataset
* An additional project and a dataset for your [Data Observatory](https://docs.carto.com/carto-user-manual/data-observatory)[ ](https://docs.carto.com/carto-user-manual/data-observatory)subscriptions.

{% hint style="warning" %}
You won't be able to create new datasets, to maintain the structure and privacy of your project.
{% endhint %}

<figure><img src="https://3029946802-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FybPdpmLltPkzGFvz7m8A%2Fuploads%2Fgit-blob-f3bff7273beadb1f29684c76246b8f5ce2cede9e%2FScreenshot%202023-04-26%20at%2018.15.10.png?alt=media" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
**Learning to use the BigQuery console**

If this is your first time using BigQuery, we recommend the following resources to get started with the BigQuery console:

* This [interactive BigQuery tutorial](https://cloud.google.com/bigquery/docs/quickstarts/query-public-dataset-console) by Google Cloud
* This [free course](https://www.coursera.org/projects/googlecloud-using-bigquery-in-the-google-cloud-console-th5it) by the Google Cloud team
  {% endhint %}

### Examples of using the console

Once you're in the console, you'll be able to run any type of SQL query or use most of the functionalities available in BigQuery. Here are some examples of use cases that can be achieved through the console:

<details>

<summary>Running non-geospatial queries</summary>

The BigQuery console lets you run all types of SQL queries, including those that don't have geospatial results. For example, to understand the average of a column without having to create a map you could run:

```sql
SELECT AVG(qty) FROM carto-dw-ac-yourid.shared.sales
```

Another approach we recommend is using [CARTO Workflows](https://docs.carto.com/carto-user-manual/workflows).

</details>

<details>

<summary>Running non-SELECT queries</summary>

In CARTO Builder, you can only run SELECT-type queries, but some methods in our [Analytics Toolbox for BigQuery](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery) are non-SELECT procedures, for example, the [Geographically Weighted Regression (GWR)](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#gwr_grid). Using the console you can run those procedures, store the result in a table and visualize it with Builder.

```sql
CALL `carto-un`.carto.GWR_GRID(
    'cartobq.docs.airbnb_berlin_h3_qk_qb',
    ['bedrooms', 'bathrooms'], -- [ beds feature, bathrooms feature ]
    'price', -- price (target variable)
    'h3_z6', 'h3', 3, 'gaussian', TRUE,
    '<project-id>.<dataset-id>.<table-name>'
);
```

Another approach we recommend is using [CARTO Workflows](https://docs.carto.com/carto-user-manual/workflows).

</details>

## Disabling the CARTO Data Warehouse

The CARTO Data Warehouse can be disabled for all users in an organization by toggling it off in the **Governance** section of the Settings. For more information, see [**Organization Governance**](https://docs.carto.com/carto-user-manual/settings/organization-governance).