We are announcing the launch of data retrieval query API (ExecuteQuery) to allow customers to access asset metadata and telemetry data for both operational and analytical use cases. With the new ExecuteQuery API customers can retrieve metadata and time-series data from asset models, assets, measurements, metrics, transforms, and aggregates using SQL-like query statements in a single API request.

The ExecuteQuery API allows developers to create industrial applications that need to retrieve data from multiple sensors within minutes of data ingestion, eliminating the need to learn or map AWS IoT SiteWise auto-generated unique identifiers for asset, asset models, and properties. For example, customers can efficiently query temperature values for a boiler with a simple query clause such as “.. asset_name LIKE ‘Boiler_A%’ AND double_value ENgt; 100.5”. Customers can use the ExecuteQuery to build efficient consumption of AWS IoT SiteWise data for operational and historical time-series analytics to drive more informed business decisions. The ExecuteQuery API also powers AWS IoT SiteWise console search, which means customers can now easily find assets based on metadata and real-time property value filters.

This feature is available in all regions where both AWS IoT SiteWise and AWS IoT TwinMaker are available, except AWS GovCloud (US-West).

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, please visit the developer guide.