Saving data as Double instead of bigint
I tested my sent data on IoT Core and the values are shown double correctly. Why the values are saved in my table as a bigint (measure_value::bigint) in Db Timestream?
IoT Core
Table in Db Timestream
Rule setting:
- Newest
- Most votes
- Most comments
Hi. It's likely that the first value of PH was exactly 8, resulting in the type being interpreted as an int. You need to handle this as covered in the developer guide here: https://docs.aws.amazon.com/iot/latest/developerguide/timestream-rule-action.html
On a different note, looks you are getting multiple measures in same event, it is recommended to use Multi-measure records in those case as it is performant, cost effective way of storing, and flexible for querying multiple metrics. https://docs.aws.amazon.com/timestream/latest/developerguide/data-modeling.html#data-modeling-multiVsinglerecords. However, IoT Core doesn't support Multi-measure as of now, you can try choosing lambda as target and and use Timestream write API (via SDKs) for ingesting data in Multi-measure format. https://docs.aws.amazon.com/lambda/latest/dg/services-iot.html https://docs.aws.amazon.com/timestream/latest/developerguide/getting-started-sdks.html
answered 2 years ago
Thanks. It would be an alternative but not serverless.