Managing your subscriptions
Admin users can check the status of the Data Observatory subscriptions on the Data Observatory tab in the Settings section. There, users will find a list of all their subscriptions, organized by provider, and specifying their status and expiration date.
By default Data Observatory subscriptions become directly available from the CARTO Data Warehouse connection. In order to get the data from your active subscriptions transferred to your own data warehouse please contact your CARTO representative to start the process.
In addition, CARTO organizations with access to the CARTO Data Warehouse also have all the Data Observatory subscriptions listed on the Data Observatory section of the Data Explorer.
From a subscription’s detail page you can access the dataset’s metadata and perform a series of actions.
From the subscription page in Data Explorer you can:
Copy the dataset’s unique ID.
Check how to access your subscription from your data warehouse using the information provided through the Access in button. Please refer to this guide to learn more.
Exporting data from your subscriptions as csv files.
Cancel your subscription. Please refer to this guide to learn more.
Exporting data
From the available actions via the Data Observatory subscription page in the Data Explorer you can also request the data to be exported and made available for download locally as csv files. Note that this functionality will only be available if the terms & conditions of your data subscription allow to leverage the data outside of the CARTO platform.
This feature leverages the resources of the CARTO Data Warehouse provided to each CARTO organization account (which is a fully-managed Google BigQuery project). The export is executed as an SQL statement that exports the results of the query to an external storage location that CARTO makes available temporarily for you. Once the export process is completed, we then provide you with the links to the different files that resulted from the export statement for you to download. Tables larger than 1GB will be divided in multiple parts. Note that the URLs for the different files have been designed in such a way that you can automate the download of all parts with a basic script that loops the calls to each part.
Note that you can also customize what subset of the data from a subscription is exported by modifying the export query with the SQL Editor available in the Export data modal screen.
For subscriptions with multiple data updates appended on the same table (and identified by the different do_date values present in the data), you can select which updates to experto by manually selecting the available 'do_date' values.
If the data from the subscription has complex fields (e.g. RECORD type columns), you will have to customize the SQL expression in order to remove or adapt those records that cannot be supported on csv file formats.
Last updated
Was this helpful?