Amazon IoT Core enhances IoT rules-SQL with variable setting and error handling capabilities
Amazon IoT Core now supports a SET clause in IoT rule-SQL, which lets you set and reuse variables across SQL statements. This new feature provides a simpler SQL experience and ensures consistent content when variables are used multiple times. Additionally, a new get_or_default() function provides improved failure handling by returning default values while encountering data encoding or external dependency issues, ensuring IoT rules continue execution successfully.
Amazon IoT Core is a fully managed service that securely connects millions of IoT devices to the Amazon Web Services. Rules for Amazon IoT is a component of Amazon IoT Core which enables you to filter, process, and decode IoT device data using SQL-like statements, and route the data to 20+ Amazon Web Services and third-party services. As you define an IoT rule, these new capabilities help you eliminate complicated SQL statements and make it easy for you to manage IoT rule-SQL failures.
These new features are available in the following Regions: Amazon Web Services China (Beijing) Region, operated by Sinnet, and the Amazon Web Services China (Ningxia) Region, operated by NWCD. For more information and getting started experience, visit developer guides on SET clause and get_or_default() function.