View your data in Amazon S3 - 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).

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 Amazon 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 Amazon IoT SiteWise.

    • asset-metadata – This folder contains asset details exported from Amazon 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 Interacting with other Amazon services.

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