Comment on page
Managing your subscriptions
You can manage all your Data Observatory subscriptions from the Data Observatory section of the Data Explorer within the CARTO Workspace:
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:
- Check the expiration date of your subscription
- 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.
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.
The option to export data is only available in case the terms and conditions of the acquired license for a particular data subscription allows to use 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.