AWS IoT Core enhances IoT rules-SQL with variable setting and error handling capabilities

Published
November 21, 2025
https://aws.amazon.com/about-aws/whats-new/2025/11/aws-iot-core-rules-sql/

AWS IoT Core Updates

AWS IoT Core now supports a SET clause in IoT rules-SQL, allowing you to set and reuse variables across SQL statements. This feature simplifies the 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 when encountering data encoding or external dependency issues, ensuring IoT rules continue execution successfully.

What to do

  • Explore the new SET clause and get_or_default() function in your IoT rules-SQL.
  • Update your IoT rules to leverage these new capabilities for a simpler SQL experience.
  • Consult the developer guides for more information on the SET clause and get_or_default() function.

Source: AWS release notes




If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.

Follow our blog

Get the latest insights and advice on AWS services from our experts.

By clicking Sign Up you're confirming that you agree with our Terms and Conditions.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.