In some cases, you may want to sync real-time data to a connected dataset. For example, you can sync to live weather source from a public URL data file or sync to a shared spreadsheet of data that is maintained on your Google Drive or Dropbox.
During the connect dataset process, select the frequency to sync the data every hour, day, week, or month.
Additionally, analysis can be applied to layers that contain a synced dataset. Every time the real-time data is refreshed, the analysis is re-run!
Before connecting to an external datasource, you must select the external service from the Connect Dataset options. This is a one-time setup. After your external connectors are enabled and connected, the connect dataset options display a list of your Google Drive, Dropbox or Box files.
For this example, suppose you have an Excel file in a Dropbox folder. With CARTO Builder, you can create a map using your data as a connected dataset and sync to the .csv file.
Enable the Dropbox connector, available from the Connect Dataset options.
Connect the dataset (or add a layer) to the live data.
To keep your connected dataset in-sync, select the desired frequency of updates to every hour, day, week, or month.
When the data is updated from the external resource, the synced data automatically updates to show the changes in CARTO.
Optionally, you can enter a public url data file to sync data to your account. For example, add a map layer connecting to public earthquake data and see how you can set the sync options.
Copy the public feed data, provided by provided by the USGS Earthquake Hazards Program.
When connecting a dataset, enter the copied url of data. For example,
You can change the sync options at anytime by accessing the dataset options.
After connecting a dataset with sync options, you can modify the frequency of sync options from Your datasets dashboard, or from accessing the original data source directly from a map layer.
From Your datasets dashboard:
From a map layer:
Synced tables cannot be edited in CARTO Builder, as the data is being pulled from another resource. If you want to edit the dataset, you can disconnect the dataset from the source by altering the sync frequency to Never. Disconnecting synced options means that the dataset is now considered local, and can be edited by adding rows and values.
We would love to hear from you! Was it easy to understand? Do you need more information? Let us know.