Accessing your subscriptions from your data warehouse
Last updated
Was this helpful?
Last updated
Was this helpful?
When a Data Observatory subscription is created, either by the CARTO team (for premium data) or automatically for public datasets, by default the data becomes available via the CARTO Data Warehouse connection. In order to get the Data Observatory subscriptions available in your own data warehouse, the CARTO team needs to transfer the tables and share access to the data via the native private sharing mechanisms of each data platform. Please contact your CARTO representative to start the data transfer process at any time.
In order to make the Data Observatory subscriptions accessible in your BigQuery account, CARTO leverages the platform of Google Cloud.
CARTO will create and maintain a listing in the Analytics Hub with the data from all your Data Observatory subscriptions. We will privately share access to that listing based on the GCP user credentials (individual, group, service account) that you share with us.
CARTO will create and maintain a listing privately shared with your Snowflake account containing the data from all your Data Observatory subscriptions.
In order to make your subscriptions available in your Redshift account, CARTO will share you access to the data in an S3 bucket (which can be provisioned by you or by CARTO).
In order to make your subscriptions available in your PostgreSQL database, CARTO will share you access to the data in an GCS bucket.
To learn more about how to access your Data Observatory subscriptions in BigQuery please check .
CARTO hosts all Data Observatory data in BigQuery's . If your BigQuery account is hosted in that specific region, you will have access to your Data Observatory subscriptions automatically. When you create a connection in CARTO to your BigQuery account in the US Multi-region location, we automatically share you access to the carto-data.
account_id
project in BigQuery where your subscription data is available. You can pin the carto-data.
account_id
dataset in your BigQuery account to ensure it is always available from your BigQuery connections in CARTO.
In order to make your subscriptions available in your Snowflake account, CARTO leverages the native mechanisms of Snowflake.
To learn more about how to access your Data Observatory subscriptions in Snowflake please check .
In order to make your subscriptions available in your Databricks account, CARTO leverages the native mechanisms of Databricks, powered by .
To learn more about how to access your Data Observatory subscriptions in Databricks please check .
To learn more about how to access your Data Observatory subscriptions in Redshift please check .
To learn more about how to access your Data Observatory subscriptions in your PostgreSQL database please check .