Data Observatory

Data Observatory

Accessing your subscriptions from your data warehouse

You can access your subscriptions directly from your data warehouses connected to CARTO. This is currently supported for BigQuery and Snowflake; Redshift and Databricks support is coming soon.

Access in BigQuery

Go to your subscription’s detail page in the Data Observatory section of the Data Explorer, then click on the Access in button and select the BigQuery option.

Access in BigQuery from your subscription page.

The following information will be displayed:

  • Location of the data table in BigQuery, in the format project.dataset.table.
  • Location of the geography table in BigQuery, in the format project.dataset.table.
  • Example query to join the data and geography tables.
Access details for BigQuery.

If your dataset subscription is a geography, such as Australia’s States by CARTO, then only one table location will be shown:

Access details for BigQuery when your subscription is a geography.

Permissions

You can use the provided access information (table locations and sample query) to query your Data Observatory subscriptions directly from BigQuery. To do so, you need to operate with BigQuery authenticated with the same credentials you have used to set up your BigQuery connection(s) in CARTO:

  • If you have set up a connection of type OAuth (using the “Sign in with Google” option), you will be granted permissions to query your Data Observatory subscriptions using the BigQuery console while you are logged in with the same Google user.
  • If your have set up a connection using a Service Account instead, you will be granted permissions to query your Data Observatory subscriptions from any BigQuery client while you are logged in using such Service Account.

Access in Snowflake

Requesting access

In order for you to access any of your Data Observatory subscriptions from Snowflake, the data first needs to be imported into your database. This import process is performed by our engineering team on a request basis.

To request it, go to the subscription’s page, click on the Access in button and choose the Snowflake option.

Access in Snowflake from your subscription page.

If you have several Snowflake connections, you will be asked to select one to perform this action:

Choose connection to access your subscriptions in Snowflake.

Finally, you will be asked to request access to the dataset from your Snowflake database.

Request to access your subscriptions in Snowflake.

Once we receive your request, we will get in touch with you to coordinate the import process. The data will be imported into a schema called CARTO that will be created in the Snowflake database you have set up in your Snowflake connection.

Checking access details

Once we have imported your Data Observatory subscription into your Snowflake database, you can check its access details through the Access in button, following the same steps described in the previous section.

The following information will be displayed:

  • Location of the data table in your Snowflake database, in the format YOURDATABASE.CARTO.TABLE.
  • Location of the geography table in your Snowflake database, in the format YOURDATABASE.CARTO.TABLE.
  • Example query to join the data and geography tables.
Access details for Snowflake.