Announcing support for JOIN operation in AWS IoT Analytics Data Stores - devamazonaws.blogspot.com

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.

Post Updated on July 27, 2021 at 10:56PM

Comments

Popular posts from this blog

Scenarios capability now generally available for Amazon Q in QuickSight - devamazonaws.blogspot.com

[MS] Introducing Pull Request Annotation for CodeQL and Dependency Scanning in GitHub Advanced Security for Azure DevOps - devamazonaws.blogspot.com

AWS Console Mobile Application adds support for Amazon Lightsail - devamazonaws.blogspot.com