Data is the lifeblood of any Ubidots project. That’s why, more often than not, the data that is older than our standard retention times is still relevant. With this in mind, we offer Data Export, which works as a safety net around your data to keep large volumes accessible, even when your normal storage limits have been reached.
Imagine facing a regulatory audit or needing to analyze metrics stretching back several years. Instead of scrambling to retrieve scattered files or worrying about storage overages, you simply pull up your archived records. Data Export makes it effortless to store and recover data at scale, so your business stays protected and ready to act, no matter what the future holds.
Requirements
This feature is charged as an add-on and is available to Enterprise plan holders.
What Is Data Export?
Data Export provides long-term data storage for datasets that exceed standard Ubidots capacity. They capture and save your data in cold storage for up to ten years, ensuring that valuable information remains accessible whenever you need it. This is especially useful for maintaining compliance, meeting audit requirements, or examining trends that stretch far back in time.
Backups are stored in AWS S3 and organized by device and variable. Multiple 40MB files are created for each variable, with every file containing approximately 2.5 million dots. This structure keeps individual files manageable and makes it easy to find exactly what you need. A simple navigator in the user interface allows you to download data as Parquet files.
The feature includes up to 500GB of cold storage—enough to hold around 32 billion dots, which covers about ten years’ worth of dots, depending on data ingestion frequency.
Access your data for up to 10 years via the Ubidots dashboard to visualize trends and historical records.
Retrieve data via API for integration with external applications and deeper analysis.
Synthetic variables are also backed up. Please note that if the expression of a synthetic variable is modified, effectively recomputing its time series values, its backup (data older than your plan's retention), will not be recalculated. This means the new data and the backed-up data will not follow the same expression.
The exported data will be available as a parquet file.
Important Notes:
Data older than 2 years may take longer to query.
Up to 10,000 variables can be backed up once per month.
Up to 50,000 queries are supported per month.
How to use Data Export
Accessing your backups requires following these simple steps:
Head over to Data ⟶ Data Export.
Once there, locate the device that contains the variable whose data you want to download by either "manually" going through the device list or by using the search bar located at the top of the page.
Click on the drop-down button at the right of the device.
Locate the variable that contains the data and click on the "download" button located at the right.
Click on the "accept" button of the modal that pops up.
