Connecting to AWS IoT and storing in Timestream database

[rtgarland]

Has anyone successfully connected to AWS IoT and stored their data that contains multi-measure data? For example, storing GPS coordinates on the same record in two separate columns? I can store single measurements easily enough, but I can't seem to figure out how to format the json to store as a multi measure record with dimensions. Any examples would be greatly appreciated. You can store multi measure in Timestream, but I'm not sure how to properly code the json object to send it in the required format.

[kenb4]

Never used it, but looking at the docs just now, it's one record per measure

AWS IoT Core - Amazon Timestream

For example, consider the SQL statement and the sample message payload:

SELECT temperature, humidity from 'iot/topic'

{
  "dataFormat": 5, 
  "rssi": -88,
  "temperature": 24.04,    
  "humidity": 43.605,    
  "pressure": 101082,    
  "accelerationX": 40,    
  "accelerationY": -20,    
  "accelerationZ": 1016,    
  "battery": 3007,    
  "txPower": 4,    
  "movementCounter": 219,    
  "device_id": 46216,
  "device_firmware_sku": 46216   
}

If an IoT Core rule action for Timestream is created with the SQL statement above, two records will be added to Timestream with measure names temperature and humidity and measure values of 24.04 and 43.605, respectively.

The data type of the measure are inferred from the data type of the value of the message payload. JSON data types such as integer, double, boolean, and string are mapped to Timestream data types of BIGINT, DOUBLE, BOOLEAN, and VARCHAR respectively.

Timestream - AWS IoT Core

Each attribute's value is written to its own record in the Timestream table.

So even if multi-measure is supported in general, it is not with the auto-magic IoT Rules (at least, not currently).

You could write something -- and with AWS, that is a voluminous can of worms -- that reads whatever JSON you post on the IoT topic and create Timestream rows in some custom way.

[rtgarland]

Thanks for the docs. I've seen other evidence that it does support it. If you create the sample database on AWS, you get an option to create single or multi measure records. I've queried that data and it does show multiple values per record. I do believe it is possible.

[rtgarland]

Store and analyze time-series data with multi-measure records, magnetic...

[kenb4]

That latter link shows using the Python API/SDK. No mention of it working directly through IoT Rules, in neither the IoT docs describing Timestream, nor the Timestream docs describing IoT.