AWS IoT Core Adds the Ability to Retrieve Data from DynamoDB using Rule SQL
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.
This feature is available in all AWS regions where AWS IoT Core is available. For more information, refer to the AWS IoT documentation.