You can use offline data storage to view device status and the Thing Specification Language (TSL) data that your devices report. Offline data includes platform system tables, time series tables, snapshot tables, and custom storage tables.
Prerequisites
Data must be backed up. For more information, see data backup.
Limits
This feature is available only for Standard and Premium instances in the China (Shanghai), China (Beijing), China (Shenzhen), Singapore, and US (Virginia) regions.
Scenarios
In addition to viewing data, storage tables support the following capabilities:
-
Query objects for SQL analysis.
-
Data sources for data API.
Platform system table
The platform system table stores information about products, devices, and device groups, such as device creation times and group relationships, to simplify device data analysis and management.
It includes product tables, device tables, device group tables, device group relationship tables, device tag tables, and device location data tables. For more information, see view platform system table.
Time series table and snapshot table
Use the time series and snapshot tables to view the Thing Specification Language (TSL) properties and event data reported by devices, organized by product and dimensions.
-
Product storage tables contain only reported properties and event data. For more information, see view product storage table.
-
For more information about Thing Specification Language, see what is Thing Specification Language.
Custom storage table
You can create custom storage tables to store data processed by Data Parsing or SQL Analysis.
-
For more information about custom storage tables, see create and view custom storage table.
-
Custom storage tables can also be used in SQL analysis:
-
New custom storage tables without data can serve as result storage for SQL analysis.
-
Custom storage tables with existing data can serve as query objects in SQL analysis.
For more information, see SQL analysis.
-