Simple IoT Core thing rule and SiteWise property alias ingestion config

Hi all,

I am posting an answer to my own question to assist others with what i consider a simple and basic plain english configuration example to: add an IoT Core single Thing to SiteWise. No OPC server, no Greengrass, no Lora. The Thing was created as a single Thing with certificates.

Setup

A single IoT thing, pulling in MQTT topic subscribed data. The Thing was created as a single Thing with certificates. A MODBUS sensor connected to a gateway with MQTT. No OPC server, no Greengrass, no Lora.

Follow the AWS IoT Core guide to create a single Thing. Is this example the Thing is a temperature sensor. Therefore use of the term 'Temperature' below relates to both: 1) the IoT SiteWise model and asset measurement fields - filled with the term 'Temperature' and, 2) the incoming IoT Core JSON payload class "Temperature" from my gateway/sensor.

• The Things name is: TestThing
• The data includes 4 fields: "TS", "datetime", "class", "data"
• The published Topic is: TestTopic
• The IoT Core MQTT Test Client payload displays as: { "TS": "1657098676", "datetime": "06/07/2022 19:11:16", "class": "Temperature", "data": 13 }
• NOTE: the JSON payload is an object. The format - with %x defined by the gateway - : {"TS": "%t", "datetime": "%d", "class": "%x", "data": %x}

IoT Core Rule config UI

• SQL Statement: SELECT * FROM 'TestTopic'
• Property Alias: AnyTermYouLike
• Time in seconds: ${TS}
• Data type: DOUBLE
• Value: ${data}
• IAM role: created via the UI - create new role

What is the Property Alias? The Property Alias required for IoT Core rule and SiteWise is the field within: SiteWise - Asset Measurement - (enter a property alias). The property alias (propertyAlias) can be any string term. In this example it is 'AnyTermYouLike'. The term must then be used in the IoT Core rule creation.

Key things to check Both within the IoT Core rule creation and for fields within IoT SiteWise model creation (Measurement definitions) the Data type: DOUBLE is used. Although a model Attribute may use: integer and or others.

SiteWise config

• Model Measurement definitions: Temperature
• Asset Measurement: Temperature
• Asset Measurement - Temperature field (enter a property alias): AnyTermYouLike
• NOTE: Asset Measurement field is the Property Alias (propertyAlias) that you define. Any term is suitable and is also used within the IoT Core rule.

Whats next?

If the IoT Core rule creation did not report errors, progress! As outlined in the manual, if the IoT Core MQTT test topic subscription is working and data is visible, the data should be following the IoT SiteWise. Within SiteWise under the asset, and measurement tab - the columns 'Latest value', and 'Latest value timestamp' should display data - new data from the subscribed MQTT topic. Switch to another tab and back to the asset, and measurement tab, the data will refresh.

Final NOTES: as described by MassimilianoAWS, the IAM role must provide access to the propertyAlias. The IoT Core rule Time in seconds, must be within the -15min +5min range. Lucky for me, the my JSON package contained Unix time and i was able to simply use: ${TS}

Additional - Two separate rules and SQL syntax to identify sensor reporting class - Temperature and Humidity

-- This is the Iot Core rule SQL syntax to select a topic field type - in this example only Temperature or Humidity - or other type of Iot Core thing field --

The sensor and thus incoming subscribed MQTT topic JSON payload contained a "class" field. Where the sensor is reporting both temperature and humidity. For each reporting period two lines of data is available - "Temperature" and "Humidity", as defined by the class. This displays as:

• { "TS": "1657101866", "datetime": "06/07/2022 20:04:26", "class": "Temperature", "data": 12}
• { "TS": "1657101866", "datetime": "06/07/2022 20:04:26", "class": "Humidity", "data": 79}

IoT Core rule config

• Create two rules.: 1) for Temperature, and 2) for Humidity
• Temperature rule SQL: SELECT * FROM "TestTopic" WHERE class = "Temperature"
• Humidity rule SQL: SELECT * FROM "TestTopic" WHERE class = "Humidity"
• Each rule will need a unique property alias (propertyAlias) that relates to the SiteWise model

SiteWise config

• Two separate models are required, one for Temperature, and the second for Humidity.
• Two separate assets, and the relationship to the corresponding model - in this case one for Temperature, and the second for Humidity.
• A primary model and a primary asset - following the AWS manual re relationships - Associated assets and Hierarchy definitions etc.
• Each model must have a unique property alias (propertyAlias) - see the section above for guidance.

In this example the property alias (propertyAlias) for the:

1. Temperature rule, and SiteWise - Asset Measurement field is: AnyTermYouLike
2. Humidity rule, and SiteWise - Asset Measurement field is: GoodSecondTerm

Close: the question subject should be called - Dummies simple guide to add a single Thing to Sitewise AND IoT Core rule property alias (propertyAlias)

Please make suggestions to improve, or correction of errors.