Posted On: Jul 27, 2021

AWS IoT Analytics now supports JOIN operation on AWS IoT Analytics data stores, enabling customers to combine data from two or more AWS IoT Analytics data stores based on a common attribute between them. Customers can now create a AWS IoT SiteWise data backed AWS IoT Analytics data store and join it with other S3 backed AWS IoT Analytics data stores to discover insights about their industrial assets such as viewing properties and relationships between various AWS IoT SiteWise assets, run statistical queries on AWS IoT SiteWise and S3 data, and perform advanced analytics. You can use this feature to create an AWS IoT Analytics SQL query data set that uses a join operation (inner join, left, right and full outer join, self join and cross join ) to combine two or more customer managed AWS IoT Analytics data stores and AWS IoT SiteWise managed data stores on a join condition using attribute names that exist in both data stores.

To get started, use the AWS IoT Analytics console to create a data set, select the data stores you want to combine data from and use the JOIN operator while authoring your SQL query. For more information on how to get started, see the JOIN page in the AWS IoT Analytics user guide.

AWS IoT Analytics is a fully managed service that makes it easy to collect, pre-process, enrich, store and analyze IoT data at scale by running and operationalizing sophisticated analytics on massive volumes of IoT data without having to worry about the complexity typically required to build an analytics platform. To learn more, please visit the AWS IoT Analytics website or the developer guide.

For a list of AWS IoT Analytics supported regions, visit AWS Regions