AWS IoT SiteWise query language
With the AWS IoT SiteWise data retrieval ExecuteQuery API operation, you can retrieve information about declarative structural definitions, and the timeseries data associated with them, from the following:
-
models
-
assets
-
measurements
-
metrics
-
transforms
-
aggregates
This can be done with SQL like query statements, in a single API request.
Note
This feature is available in all Regions where both AWS IoT SiteWise and AWS IoT TwinMaker are available, except AWS GovCloud (US-West).
Prerequisites
AWS IoT SiteWise requires permissions to integrate with AWS IoT TwinMaker so that it can organize and model industrial data.
Before you can retrieve information about models, assets, measurements, metrics, transforms, and aggregates, ensure the following prerequisites are met:
-
Service-linked roles for both AWS IoT SiteWise and AWS IoT TwinMaker setup in your AWS account. For more information about service-linked roles, see Create a service-linked role in the IAM User Guide.
-
An enabled AWS IoT SiteWise integration for your IAM role. For more information, see Integrate AWS IoT SiteWise and AWS IoT TwinMaker.
-
An AWS IoT TwinMaker workspace with ID
IoTSiteWiseDefaultWorkspacein your account in the Region. For more information, see Using the IoTSiteWiseDefaultWorkspace in the AWS IoT TwinMaker User Guide. -
Either the standard or tiered bundle pricing modes for AWS IoT TwinMaker enabled. For more information, see Switch AWS IoT TwinMaker pricing modes in the AWS IoT TwinMaker User Guide.
