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 Analytics Hub platform of Google Cloud.
CARTO hosts all Data Observatory data in BigQuery's US Multi-region. Automatically we share access to your subscriptions hosted in that location to any of your BigQuery connections. However, in order to be able to enrich your own data hosted in a different location with your Data Observatory subscriptions, CARTO needs to transfer the data directly to your BigQuery account in your own region.
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.
To learn more about how to access your Data Observatory subscriptions in BigQuery please check this section.
CARTO hosts all Data Observatory data in BigQuery's US Multi-region. 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 private sharing 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 learn more about how to access your Data Observatory subscriptions in Snowflake please check this section.
In order to make your subscriptions available in your Databricks account, CARTO leverages the native private exchanges mechanisms of Databricks, powered by Delta Sharing.
To learn more about how to access your Data Observatory subscriptions in Databricks please check this section.
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).
To learn more about how to access your Data Observatory subscriptions in Redshift please check this section.
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 your PostgreSQL database please check this section.
