AWS IoT Core now supports a SET clause in IoT rules-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.
AWS IoT Core is a fully managed service that securely connects millions of IoT devices to the AWS cloud. Rules for AWS IoT is a component of AWS IoT Core which enables you to filter, process, and decode IoT device data using SQL-like statements, and route the data to 20+ AWS 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 rules-SQL failures.
These new features are available in all AWS Regions where AWS IoT Core is available, including AWS GovCloud (US) and Amazon China Regions. For more information and getting started experience, visit the developer guides on SET clause and get_or_default() function.
Categories: marketing:marchitecture/developer-tools,marketing:marchitecture/internet-of-things
Source: Amazon Web Services
Latest Posts
- Power Automate – Analyze your processes in the process intelligence experience [MC1296213]
![Power Automate - Analyze your processes in the process intelligence experience [MC1296213] 2 pexels towfiqu barbhuiya 3440682 11921157](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)
- Power Pages – Support for Power BI Embed Token v2 for Power Pages [MC1296201]
![Power Pages – Support for Power BI Embed Token v2 for Power Pages [MC1296201] 3 pexels pixabay 208560](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)
- Dynamics 365 Contact Center – Average wait time in messaging API channels [MC1296211]
![Dynamics 365 Contact Center – Average wait time in messaging API channels [MC1296211] 4 pexels anniroenkae 2156881](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)
- Dynamics 365 Contact Center – Pinned contacts and queues during consult and transfer [MC1296218]
![Dynamics 365 Contact Center - Pinned contacts and queues during consult and transfer [MC1296218] 5 pexels eye4dtail 134402](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)

![Power Automate - Analyze your processes in the process intelligence experience [MC1296213] 2 pexels towfiqu barbhuiya 3440682 11921157](https://mwpro.co.uk/wp-content/uploads/2025/06/pexels-towfiqu-barbhuiya-3440682-11921157-150x150.webp)
![Power Pages – Support for Power BI Embed Token v2 for Power Pages [MC1296201] 3 pexels pixabay 208560](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-pixabay-208560-150x150.webp)
![Dynamics 365 Contact Center – Average wait time in messaging API channels [MC1296211] 4 pexels anniroenkae 2156881](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-anniroenkae-2156881-150x150.webp)
![Dynamics 365 Contact Center - Pinned contacts and queues during consult and transfer [MC1296218] 5 pexels eye4dtail 134402](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-eye4dtail-134402-150x150.webp)
