How to show decimal in my timestream Query

Question

Hi, I am new to timestream. I am currently trying to send payload through MQTT. In my payload, there is only the following:

"device_id": "Device 1",
"a_x": 101.68888

When I run my query in my database, only Device 1 is shown. The a_x and 101.68888 are not reflected. Is it possible for timstream to show decimal values?

Here is my SQL in my Iot Core rule
SQL version: 2015-10-08
SELECT*, a_x FROM 'outTopic'

Thank you.

Answer

Timestream provides a recommended solution for using IoT topic rules to insert MQTT data into Timestream:

https://github.com/awslabs/amazon-timestream-tools/tree/mainline/integrations/iot_core

How to show decimal in my timestream Query

Conteúdo relevante