Analyze the exported data with Amazon Athena - Amazon IoT SiteWise
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Analyze the exported data with Amazon Athena

After you have your asset property data in Amazon S3, you can use several Amazon services to generate reports or analyze and query your data:

You can find other Amazon services that can interact with your data in Amazon S3 listed under Analytics in the Amazon Web Services Management Console.

Note

The stack creates an Amazon Glue database to format asset property data. You can't query this database for asset data. Follow the steps in this section to create an Amazon Glue database that you can query.

In this tutorial, you learn how to configure the prerequisites to use Amazon Athena and how to use Athena to run SQL queries on your exported Amazon IoT SiteWise asset data. To query data with Athena, you must first populate the Amazon Glue Data Catalog with your asset data. The Data Catalog contains databases and tables, and Athena can access data in the Data Catalog. You can create an Amazon Glue crawler that regularly updates the Data Catalog with your exported asset data.

Topics