View your data in Amazon S3 - AWS IoT SiteWise

View your data in Amazon S3

After you create the feature, you can view your asset property data and asset metadata in Amazon S3.

Note

Asset metadata updates every six hours. You might need to wait up to six hours to see asset metadata appear in the S3 bucket.

This feature stores asset property data in the following columns, where each row contains a data point:

  • type – The type of property notification (PropertyValueUpdate).

  • asset_id – The ID of the asset that received a data point.

  • asset_property_id – The ID of the property that received a data point for the asset.

  • time_in_seconds – The time at which the data was received, expressed in seconds in Unix epoch time.

  • offset_in_nanos – The nanosecond offset from timeInSeconds.

  • asset_property_quality – The quality of the data point: GOOD, UNCERTAIN, or BAD.

  • asset_property_value – The value of the data point.

  • asset_property_data_type – The data type of the asset property: boolean, double, integer, or string.

This feature stores asset metadata in the following columns, where each row contains an asset property:

  • asset_id – The ID of the asset.

  • asset_name – The name of the asset.

  • asset_model_id – The ID of the asset's model.

  • asset_property_id – The ID of the asset property.

  • asset_property_name – The name of the asset property.

  • asset_property_data_type – The data type of the asset property: BOOLEAN, DOUBLE, INTEGER, or STRING.

  • asset_property_unit – The unit of the asset property.

  • asset_property_alias – The alias of the asset property.

To view your AWS IoT SiteWise data in Amazon S3

  1. Navigate to the Amazon S3 console.

  2. From the list of buckets, choose the bucket with the name you chose when you created the template.

  3. In the bucket, choose one of the following folders:

    • asset-property-updates – This folder contains asset property data exported from AWS IoT SiteWise.

    • asset-metadata – This folder contains asset details exported from AWS IoT SiteWise.

  4. Choose the object that you want to view.

  5. On the object's page, do the following:

    1. Choose the Select from tab.

      In this panel, you can preview records from Parquet files.

    2. For File format, choose Parquet.

    3. To show the contents of the file in JSON format, choose Show file preview.

Note

If new data doesn't appear in the bucket, check that you enabled property value update notifications for your asset properties. For more information, see Interact with other AWS services.

For more information about how to analyze your asset data stored in the S3 bucket, see Analyze the exported data with Amazon Athena.