Publish property value updates to Amazon DynamoDB

To enable property value update notifications on asset properties

1. Sign in to the Amazon IoT SiteWise console.

2. Review the Amazon IoT SiteWise endpoints and quotas where Amazon IoT SiteWise is supported and switch Amazon Regions, if necessary. Switch to a Region where you're running the Amazon IoT SiteWise demo.

3. In the left navigation pane, choose Assets.

4. Choose the arrow next to Demo Wind Farm Asset to expand the wind farm asset's hierarchy.

5. Choose a demo turbine and choose Edit.

6. Choose Measurements.

7. Update the Wind Speed property's MQTT Notification status to ACTIVE.

8. Choose Save at the bottom of the page.

9. Repeat steps 5 through 7 for each demo turbine asset.

10. Choose a demo turbine (for example, Demo Turbine Asset 1).

11. Choose Measurements.

12. Choose the copy icon next to the Wind Speed property to copy the notification topic to your clipboard. Save the notification topic to use later in this tutorial. You only need to record the notification topic from one turbine.

    The notification topic should look like the following example.

    $aws/sitewise/asset-models/a1b2c3d4-5678-90ab-cdef-11111EXAMPLE/assets/a1b2c3d4-5678-90ab-cdef-22222EXAMPLE/properties/a1b2c3d4-5678-90ab-cdef-33333EXAMPLE

To create a rule with a DynamoDB action

1. Navigate to the Amazon IoT console.

2. In the left navigation pane, choose Message routing, and then choose Rules.

3. Choose Create rule.

4. Under Specify rule properties, enter a name and description for the rule.

5. Find the notification topic that you saved earlier in this tutorial.

   $aws/sitewise/asset-models/a1b2c3d4-5678-90ab-cdef-11111EXAMPLE/assets/a1b2c3d4-5678-90ab-cdef-22222EXAMPLE/properties/a1b2c3d4-5678-90ab-cdef-33333EXAMPLE

   Replace the asset ID (the ID after assets/) in the topic with a +. This selects the wind speed property for all demo wind turbine assets. The + topic filter accepts all nodes from a single level in a topic. Your topic should look like the following example.

   $aws/sitewise/asset-models/a1b2c3d4-5678-90ab-cdef-11111EXAMPLE/assets/+/properties/a1b2c3d4-5678-90ab-cdef-33333EXAMPLE

6. Enter the following rule query statement. Replace the topic in the FROM section with your notification topic.

   SELECT
     payload.assetId AS asset,
     (SELECT VALUE (value.doubleValue) FROM payload.values) AS windspeed,
     timestamp() AS timestamp
   FROM
     '$aws/sitewise/asset-models/a1b2c3d4-5678-90ab-cdef-11111EXAMPLE/assets/+/properties/a1b2c3d4-5678-90ab-cdef-33333EXAMPLE' 
   WHERE
     type = 'PropertyValueUpdate'

7. Under Rule actions, navigate to Action 1.

8. On the Select an action page, choose DynamoDBv2. This splits the message into multiple columns of a DynamoDB table

9. Under Table name, choose Create new table. You create an Amazon DynamoDB table to receive wind speed data from the rule action.

10. Under Table name in the DynamoDB console enter a name for your table.

11. For Partition key, do the following:

    1. Enter timestamp as the partition key.

    2. Choose the Number type.

    3. Select the Add sort key check box.

    4. Enter asset as the sort key, and leave the default sort key type of String.

12. Choose Create table.

13. Return to the tab with the Configure action page.

14. On the Attach rule action page, refresh the Table name list, and choose your new DynamoDB table you created in the previous step.

To configure the DynamoDB rule action

1. Choose Create role to create an IAM role that grants Amazon IoT Core access to perform the rule action.

2. Enter a role name, for example, WindSpeedDataRole. Choose Create role.

3. Choose Next.

4. Choose Create at the bottom of the page to finish creating the rule.

   Your demo asset data should start appearing in your DynamoDB table.

To explore asset data in DynamoDB

1. Return to the tab with the DynamoDB table open.

2. In the table you created earlier, choose the Explore table items tab to view the data in the table. Refresh the page if you don't see rows in the table. If rows don't appear after a few minutes, see Troubleshoot a rule (DynamoDB).

3. In a row in the table, choose the edit icon to expand the data.

4. Choose the arrow next to the windspeed structure to expand the list of wind speed data points. Each list reflects a batch of wind speed data points sent to Amazon IoT SiteWise by the wind farm demo. You might want a different data format if you set up a rule action for your own use. For more information, see Query asset property notifications in Amazon IoT SiteWise.

The Amazon IoT SiteWise demo deletes itself after a week, or the number of days you chose if you created the demo stack from the Amazon CloudFormation console. You can delete the demo before if you are done using the demo resources. You can also delete the demo if the demo fails to create. Use the following steps to delete the demo manually.

(optional) To delete the Amazon IoT SiteWise demo

1. Navigate to the Amazon CloudFormation console.

2. Choose IoTSiteWiseDemoAssets from the list of Stacks.

3. Choose Delete.

   When you delete the stack, all of the resources created for the demo are deleted.

4. In the confirmation dialog, choose Delete stack.

   The stack takes around 15 minutes to delete. If the demo fails to delete, choose Delete in the upper-right corner again. If the demo fails to delete again, follow the steps in the Amazon CloudFormation console to skip the resources that failed to delete, and try again.

To disable property value update notifications on asset properties

1. Navigate to the Amazon IoT SiteWise console.

2. In the left navigation pane, choose Assets.

3. Choose the arrow next to Demo Wind Farm Asset to expand the wind farm asset's hierarchy.

4. Choose a demo turbine and choose Edit.

5. Update the Wind Speed property's Notification status to INACTIVE.

6. Choose Save asset at the bottom of the page.

7. Repeat steps 4 through 6 for each demo turbine asset.

To disable or delete a rule in Amazon IoT Core

1. Navigate to the Amazon IoT console.

2. In the left navigation pane, choose Message routing and then choose Rules.

3. Select your rule and choose Delete.

4. In the confirmation dialog, enter the name of the rule and then choose Delete.

To delete a DynamoDB table

1. Navigate to the DynamoDB console.

2. In the left navigation pane, choose Tables.

3. Choose the table you created earlier, for example, WindSpeedData.

4. Choose Delete.

5. In the confirmation dialog, enter confirm to delete the table.