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

![Site attestation policy is now generally available [MC1198075] 2 pexels pachon in motion 426015731 18545013](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-pachon-in-motion-426015731-18545013-150x150.webp)
![Updates available for Microsoft 365 Apps for Current Channel [MC1198067] 3 giraffe 5767909 1920](https://mwpro.co.uk/wp-content/uploads/2025/06/giraffe-5767909_1920-150x150.webp)
![Microsoft Entra: Cross-tenant security group synchronization [MC1198077] 4 pexels alexasfotos 32112166](https://mwpro.co.uk/wp-content/uploads/2025/06/pexels-alexasfotos-32112166-150x150.webp)
![Migrate User Data Across Tenants: Mailboxes, OneDrives, and Teams Chats [MC1198079] 5 pexels pixabay 36753](https://mwpro.co.uk/wp-content/uploads/2025/06/pexels-pixabay-36753-150x150.webp)
