Products
Ubidots smart storage blends hot and cold databases so you can query billions of data points across a decade — without managing infrastructure.




How it Works
Ubidots combines high-speed hot storage for recent data with cost-efficient cold storage for historical archives. The result: fast queries on fresh data and reliable access to years of history — all from one platform.
Recent data lives in high-performance databases optimized for dashboards, alerts, and API queries. Every dot is available in milliseconds, powering the real-time monitoring your operations depend on.




As data ages, Ubidots automatically archives it to AWS S3 in optimized Parquet files. Each 40 MB file holds roughly 2.5 million data points, organized by device and variable for efficient retrieval.
Whether data is one hour old or five years old, you access it from the same interface. The platform routes queries to the right storage tier transparently — no manual exports or external tools required.


Key Features

Preserve up to a decade of IoT data without worrying about storage overages or data loss.

Archive approximately 32 billion data points in cost-efficient AWS S3 cold storage.

Data stored in columnar Parquet format for fast, efficient reads across massive datasets.

Archives are structured by device and variable, making targeted retrieval fast and logical.

Up to 10,000 variables archived monthly, keeping your cold storage consistently up to date.

Generous query quota ensures teams can explore historical data without hitting walls.

Browse and export archived data directly from the Ubidots UI — no SQL or CLI needed.

Visualize historical trends alongside real-time data on the same Ubidots dashboards.

Retrieve archived data points programmatically for integration with BI tools and external systems.


Quantify Environmental uses wireless IoT sensors and Ubidots dashboards to turn utility data into real-time insights, helping industrial clients monitor water, energy, and gas use, detect inefficiencies, and act before costs rise.
$250,000+ in annual client savings through optimized water, electricity, and gas consumption.
Millions of liters of fresh water conserved and tons of CO₂ emissions prevented driving measurable sustainability outcomes.
Improved operational oversight with real-time visibility into utility usage and equipment performance.
Success Story


Use Cases

Tom Ulanowski
Co-Founder
Quantify Environmental uses Ubidots to monitor utilities across sites, helping clients cut costs through real-time data and alerts.
Results:


Steve Barker
Founder & CEO
Prospect Control uses Ubidots to deliver remote tank level monitoring for industrial customers, replacing complex PLC/SCADA setups with a scalable, web-based IoT solution.
Results:


Darryl Schembri
General Manager
AIS Technology uses Ubidots to monitor electricity, water, and gas consumption across multi-tenant buildings, enabling real-time visibility, automated billing, and faster response to inefficiencies.
Results:


Onofre Tamargo
CEO & Cofounder
S4IoT uses Ubidots to remotely monitor irrigation systems in urban gardens, helping clients reduce maintenance costs, prevent plant loss, and shift from manual operations to a scalable subscription-based model.
Results:

Help & Support
Have questions about Ubidots? Here are some ofthe most common queries to help you get started.
Ubidots uses a two-tier smart storage architecture. Recent data stays in a high-performance hot database optimized for real-time dashboards and fast queries. As data ages, it is automatically archived to cold storage on AWS S3 in Parquet format — organized per variable, with no infrastructure management required. A unified query layer lets you access both tiers from a single interface, with no manual migration.
Long-term retention supports up to 500 GB of cold storage — approximately 32 billion data points, covering around ten years of IoT data depending on ingestion frequency. Archived data is stored in Parquet columnar files (~2.5 million data points per 40 MB file), organized per device and variable. Up to 10,000 variables can be archived monthly, with a quota of 50,000 queries per month.
Yes. Ubidots provides a built-in data navigator that lets you browse and visualize archived data directly from the dashboard — no SQL or external tools required. Historical data can also be accessed via REST API or downloaded as Parquet files per variable. Note that data older than two years may experience slightly slower query performance due to the cold storage tier.
No. Long-term retention (Extended Storage) is available as a paid add-on for Enterprise plan holders only. It is not included in Professional or Industrial plans. The add-on provides up to 500 GB of cold storage, a 50,000 monthly query quota, and up to 10,000 variables archived per month. Contact the Ubidots sales team for pricing and availability.

