AWS IoT SiteWise Query API adds advanced SQL support and ODBC driver
We are announcing major enhancements to the AWS IoT SiteWise Query API (ExecuteQuery) to support a suite of advanced SQL capabilities, empowering customers to perform sophisticated data analysis on their industrial data and business intelligence tool integration. Customers can now leverage advanced SQL operations including string manipulation (such as pattern matching and substring extraction), aggregation functions (e.g., grouping, SUM, COUNT, and more on telemetry streams), multi-field sorting, and robust datetime operations for time-based analytics. Furthermore, we are introducing an ODBC driver, enabling direct integration with BI tools like Tableau, Power BI, and Excel for enhanced data visualization and reporting on operational data—without custom development or middleware.
These enhancements enable customers to execute advanced queries such as "SELECT avg(rts.double_value), a.asset_name FROM raw_time_series rts, asset a, asset_property ap WHERE a.asset_name LIKE 'Boiler%' AND ap.property_name = 'Temperature' AND rts.event_timestamp > TIMESTAMP '2025-04-15 09:00:00' AND rts.event_timestamp < TIMESTAMP '2025-04-15 17:00:00' GROUP BY a.asset_name ORDER BY 1" to analyze average boiler temperatures during business hours. This helps streamline the path from industrial data collection to actionable business insights.
This enhanced feature is available in the following AWS Regions: Asia Pacific (Tokyo), Asia Pacific (Seoul), Asia Pacific (Mumbai), Asia Pacific (Singapore), Asia Pacific (Sydney), Europe (Ireland), Europe (Frankfurt), US East (N. Virginia), US West (Oregon). The ODBC driver is compatible with Windows environments.
AWS IoT SiteWise is a managed service that makes it easy to collect, store, organize and analyze data from industrial equipment at scale to help you make data-driven decisions. To learn more about the enhanced Query API and download the ODBC driver, please visit the user guide.