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
- (Updated) Microsoft 365 Copilot: Navigation refresh in the M365 Copilot app [MC1187677]
![(Updated) Microsoft 365 Copilot: Navigation refresh in the M365 Copilot app [MC1187677] 2 pexels annamw 1106479](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)
- Microsoft 365 Copilot for Sales – Engage prospects faster with Sales Agent-enriched leads [MC1231406]
![Microsoft 365 Copilot for Sales - Engage prospects faster with Sales Agent-enriched leads [MC1231406] 3 pexels pachon in motion 426015731 18545020](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)
- (Updated) Migration update for Office 365 connectors retirement in Teams – webhook URL support [MC1181996]
![(Updated) Migration update for Office 365 connectors retirement in Teams – webhook URL support [MC1181996] 4 pexels googledeepmind 17483906](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)
- AWS Backup adds cross-Region database snapshot copy to logically air-gapped vaults


![(Updated) Microsoft 365 Copilot: Navigation refresh in the M365 Copilot app [MC1187677] 2 pexels annamw 1106479](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-annamw-1106479-150x150.webp)
![Microsoft 365 Copilot for Sales - Engage prospects faster with Sales Agent-enriched leads [MC1231406] 3 pexels pachon in motion 426015731 18545020](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-pachon-in-motion-426015731-18545020-150x150.webp)
![(Updated) Migration update for Office 365 connectors retirement in Teams – webhook URL support [MC1181996] 4 pexels googledeepmind 17483906](https://mwpro.co.uk/wp-content/uploads/2025/06/pexels-googledeepmind-17483906-150x150.webp)

