1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
1
Hi. You should use the time_to_epoch()
function in the Timestamp value of the Rule Action. In your case:
${time_to_epoch(timestamp,"yyyy-MM-dd'T'HH:mm:ss'Z'")}
Please see the discussion of time_to_epoch()
here: https://docs.aws.amazon.com/iot/latest/developerguide/timestream-rule-action.html
I don't want ts to also end up as a metric, and I'm not sure how to prevent that.
Please change your rule query statement to:
SELECT fields.rms0 as rms0, fields.rms1 as rms1 FROM 'foo/bar'
관련 콘텐츠
- AWS 공식업데이트됨 일 년 전
- AWS 공식업데이트됨 3년 전
So you are saying it will pull the attribute named 'timestamp' out of my JSON even though it's not part of the SELECT?
I am indeed saying that. And I tested it before saying that. :-)
Thank you very much. It works great!!!
Thankyou for posting this, but what do I put as the Timestamp unit ?
time_to_epoch() returns the epoch time in milliseconds.