I have an IOT Device sending temperature, humidity and pressure to AWS IOT Core and, with a rule, send it to an Amazon Timestream DB, using the following SQL statement in the IOT Core rule:
SELECT temperature, humidity, pressure FROM 'devicepub/data/#'
At the moment, I have one record per measure.
However I want to use the new feature of Timeseries, which allows multi-measure records and, therefore, obtain one record per timestamp, which includes all the variables measured.
How should I write the IOT Core rule?
Is it actually possible to do that know?