Save data to Alibaba Tablestore

Click . Time Series Table. Create Time Series Table.

Click on the Time Series Table created in the previous step to enter the timeline management UI. Click Data Management, Query Data, and Add Time Series according to the business design. (This step can be skipped, Tablestore will automatically create a new Time Series when writing data that does not exist. The example does not operate on Time Series)

Click Resources Create. Find the Tablestore(Time Series).

AccessKey & Secret need to use Alibaba Cloud account application, detailed application steps, please refer to the official documentation of Tablestore.
Please fill in different domain names according to the deployment method for the server address.

Rule SQL used in the example:

Table Name and Data Source name, please fill in the Table Name and name as created (Data Source name can be empty string).

Tablestore supported data types:

• int
• boolean
• string
• binary

These types can be automatically recognized and classified by the rules engine. String data, however, is handled as a binary by default to ensure the best compatibility. If you need to specify a field value as a string, you can fill the field into the String Fields when you create the action. After that, the engine will handle the field value as a string.

Test Data

Use the advanced desktop MQTT client, MQTT X, to log into the device and send a piece of data.

Enter the metric name (the demo uses m_re2), the client ID is 123456, we use client=123456 as the query condition and click .

You can see that the data has been written successfully.