Load and verify data - AWS IoT Analytics
Next Step

End of support notice: On December 15, 2025, AWS will end support for AWS IoT Analytics. After December 15, 2025, you will no longer be able to access the AWS IoT Analytics console, or AWS IoT Analytics resources. For more information, see AWS IoT Analytics end of support.

Load and verify data

The data you query in this tutorial is a sample set of AWS IoT SiteWise data that models wind engine turbines in a wind farm.

Note

You will query three tables in your data store throughout this tutorial:

  • raw ‐ Contains raw, unprocessed data for each asset.

  • asset_metadata ‐ Contains general information about each asset.

  • asset_hierarchy_metadata ‐ Contains information about the relationships between assets.

To run the SQL queries in this tutorial

  1. Follow the steps in Create a dataset with AWS IoT SiteWise data (Console) or Create a dataset with AWS IoT SiteWise data (AWS CLI) to create an AWS IoT Analytics dataset for your AWS IoT SiteWise data.

  2. To update your dataset query throughout this tutorial, do the following.

    1. In the AWS IoT Analytics console, on the Datasets page, choose the name of the dataset you created on the previous page.

    2. On the dataset summary page, choose Edit to edit your SQL query.

    3. To display the results in a table following the query, choose Test query.

    Alternatively, you can run the following update-dataset command to modify the SQL query with the AWS CLI.

    aws iotanalytics update-dataset --cli-input-json file://update-query.json

    Contents of update-query.json:

    {
    "datasetName": "my_dataset",
    "actions": [
        {
            "actionName": "myDatasetUpdateAction",
            "queryAction": {
                "sqlQuery": "SELECT * FROM my_iotsitewise_datastore.asset_metadata LIMIT 3"
            }
        }
    ]
}

  3. In the AWS IoT Analytics console or with the AWS CLI, run the following query on your data to verify that your asset_metadata table loaded successfully.

    SELECT COUNT(*) FROM my_iotsitewise_datastore.asset_metadata
    Count

    97

    Similarly, you can verify that your asset_hierarchy_metadata and raw tables aren't empty.

Next Step

Data exploration