Posted On: Oct 8, 2019
You can now retrieve additional data from DynamoDB tables as part of the rule processing in AWS IoT Core. To do so, simply use the get_dynamodb() function in the SQL statement of your rule, either in the SELECT clause to enrich message payload or in the WHERE clause to evaluate a condition with context from a DynamoDB table of your choice.
For example, you can monitor a motor’s performance by tracking the motor’s reported amperage readings and the belt speed on the motor, which is reported by a different sensor and can be stored in a DynamoDB table. If the motor’s amperage reading is above a threshold and the belt speed is close to zero, an SNS action can be triggered to notify the technician that the motor is likely stuck.