Amazon 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 Amazon 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 both Amazon Web Services China (Beijing) Region, operated by Sinnet and Amazon Web Services China (Ningxia) Region, operated by NWCD. For more information, refer to the Amazon IoT documentation.