inserting data into timestream table
I have generated a timestream database and table, but am struggling to write data to the table. The data comes from an mqtt topic, and can be seen in the cloudwatch log, so I know my select statement is sound. I think i have given the IAM role the correct permissions.
This answer [https://repost.aws/questions/QUmWAjLqG7RwGHCSL2tMrXvw/iot-core-rules-to-map-timestamp-to-timestream#COMoUviJP_TGCAgZvcltBQUw](by @Greg_b) describes how to enter the 'timestamp value' but does not say what is needed in the 'timestamp unit' field. I am a complete newcomer to AWS so apologies if my question is not worded correctly. I would really appreciate some help with this!
One further question, why, after i have deactiveted a rule, does it still appear in the cloudwatch logs?
Hi.
The data comes from an mqtt topic, and can be seen in the cloudwatch log, so I know my select statement is sound. I think i have given the IAM role the correct permissions.
Are you looking in the AWSIotLogsV2 log group? And at the RuleMatch and RuleExecution event types?
https://docs.aws.amazon.com/iot/latest/developerguide/cwl-format.html#rule-engine-logs
If your rule is suffering an error during the rule action, you should see it in the RuleExecution event type.
One further question, why, after i have deactiveted a rule, does it still appear in the cloudwatch logs?
This question makes me think you're not looking at RuleExecution.
describes how to enter the 'timestamp value' but does not say what is needed in the 'timestamp unit' field
time_to_epoch() returns the epoch time in milliseconds.
IoT logging is not enabled by default, so you will need to enable it: https://docs.aws.amazon.com/iot/latest/developerguide/configure-logging.html
Relevant questions
Ingesting IoT Data to Timestream with Timestamp
Accepted Answerasked 2 years agoTimestream Historical Data (10s of years old)
asked 3 months agoSource Data for TimeStream Database
asked 6 months agoTimeStream and time zones
asked 2 months agoInsert historic data
asked 2 years agoinserting data into timestream table
Accepted Answerasked 2 months agoI am trying to write an ETL job to the Data Catalog but its writing the Headers as Data
Accepted Answerasked 4 months agoHow to add data into aws timestream that's older than the memory store retention period?
asked 3 months agoI need to read S3 data, transform and put into Data Catalog. Should I be using a Crawler?
Accepted Answerasked 4 months agoinserting data from MQTT into dynamodb
asked 2 months ago
thanks for this answer, how do I see the AWSIotLogsV2 group, it's not listed in my log groups?