IoT Platform:Manage system tables and time series/snapshot tables

View storage tables

1. Access the IoT Platform console.

2. On the Instance Overview page, locate the desired Enterprise Edition instance and click it to open the Instance Details page.

3. In the left-side navigation pane, choose DataService Studio > Data Storage.

4. Navigate to the Data Storage page and select the Offline Storage tab.

5. Choose either the System Tables or Time Series/Snapshot Tables tab to view the respective storage table type.

   System tables

   These tables provide information on created products and devices.

   • Product Table: Contains metadata for backed-up instances, such as ProductKey, name, creation and modification times.

   • Device Table: Includes metadata for backed-up instances, like the product's unique identifier (IotId), activation time, status, physical address, and device type.

   • Device Group Table: Holds group information for backed-up instances, including group type, name, and description.

   • Device Group Relationship Table: Details the relationships between devices and groups.

   • Device Tag Table: Stores tag information added to devices.

   • Device Location Data Table: Records latitude, longitude, and province/city information for devices.

   Time series/snapshot tables

   Note

   IoT data services are case-insensitive. To prevent initialization failures of time series and snapshot tables, avoid using identical property definitions with different cases in the Thing Specification Language for products and twin nodes.

   • Product dimension: Following an instance backup, the Time Series/snapshot Table list is automatically populated with the corresponding product's Time Series/snapshot Table. Data will appear in the automatically created product storage table only after the device submits property and event data as defined by the Thing Specification Language.

   Under the Time Series/snapshot Table tab, use the search box to look up a specific storage table by entering the product name, or the storage table name. To filter by table type, simply click Table Type (all) followed by .

   • Product Property Time Series Table: Archives historical data of device-reported properties.

   • Product Property Snapshot Table: Captures the latest reported property data from devices.

   • Product Event Table: Stores historical data of device-reported events.

6. The storage table list allows for various operations to view detailed information.

   View

   Select View in the Operation column to access the Basic Information and Table Structure of the table.

   • Basic Information

     Item	Example	Description
     Table Identifier	${system.device_group_relation}	The unique identifier for the storage table.
     Table Display Name	Device Group Relationship Table	The display name of the storage table.
     Number of Fields	8	The total number of fields in the storage table.
     Data Source	System Data Source	The origin of the data, which can be: System Data Source: Originates from system tables. Product Property Data Source, Product Event Data Source: Comes from time series or snapshot tables.
     Description	This table outlines the relationship between devices and groups.	The purpose and content of the storage table.

   • Table Structure: Provides details on the storage table's fields, including names and types.

   Data preview

   Click Data Preview in the Operation column to review the storage table's data details.

   Note

   By default, the latest 20 data entries are displayed.

Export storage table data

1. Within the Time Series/Snapshot Table tab, click the Operation column next to the desired table, then select Export or More > Export to initiate the export process.

   Important

   You can create only one export task at a time, with a limit of three tasks per day. Each task allows for three downloads.

2. Go to the Export Task Details page and click Create Export Task.

3. In the dialog box, configure the following parameters:

   Parameter	Description
   Time Range of Exported Data	Select a time range for the data export, up to 3 days.
   Export File Name	The file name can include Chinese characters, English letters, numbers, and underscores (_), but cannot start with a number or underscore, and must be under 30 characters in length.
   CSV File Separator for Export	The separator must be a VERTICAL LINE.

4. Select Confirm.

   Once the export task has been successfully established, select View in the operation column to access the task's export log.

5. Once the task is completed successfully, download the CSV file locally by clicking Download in the operation column.

Enable real-time data integration (Flink)

The Product Property Time Series Table and Product Event Table support the activation of Flink Tasks. Once enabled, you can leverage real-time computing with Flink to analyze and monitor device conditions, detect operational issues, and predict product yields in real time.

Note that real-time data integration in DataService Studio consumes Data Processing Units (DPU).

1. In the Time Series/Snapshot Table tab, locate the desired product property time series or event table and click View in the Operation column.

2. On the product page, activate the Flink Task by clicking the corresponding icon .

3. Confirm the enablement by clicking Confirm Enable in the dialog box.

Disable real-time data integration (Flink)

If real-time computing with Flink is not required for your business needs, you can disable Flink tasks by following these steps:

1. On the product page, toggle the Flink Task switch to the off position, indicated by the icon.

2. To confirm, click Confirm Disable.

What to do next

• For SQL analysis, system tables, time series tables, and snapshot tables can serve as query objects to further analyze and utilize data.

• For offline data integration with DataWorks and MaxCompute, integrate data from system tables, product property time series tables, product property snapshot tables, and product event tables into Alibaba Cloud's big data platform to enhance data application efficiency.

• For real-time data integration with Flink, integrate data from the product property time series table and product event table into Alibaba Cloud's real-time computing platform for analysis and diagnostics.