AWS IoT - Device data to dashboard in 10 minutes - A demonstration

Introduction

This tutorial provides a step-by-step guide on how to connect an IoT device to AWS IoT Core, store telemetry data in Amazon Timestream, and display this data in an Amazon Managed Grafana dashboard. This process is crucial for monitoring and visualizing data from IoT devices, enabling real-time insights.

Step 1: Understand the End-to-End Architecture

Before diving into implementation, familiarize yourself with the overall architecture. The key components include:

• AWS IoT Core: The service that connects your IoT devices to the cloud.
• Amazon Timestream: A time-series database service to store telemetry data.
• Amazon Managed Grafana: A visualization tool to create dashboards for monitoring data.

Step 2: Create the AWS IoT Core Thing

1. Log into the AWS Management Console.
2. Navigate to the IoT Core service.
3. Select "Manage" and then click on "Things".
4. Choose "Create thing".
5. Input the necessary details for your IoT device:
   • Name your Thing.
   • Optionally, add a type and group.
6. Click "Create thing" to finalize.

Step 3: Send IoT Client Data to AWS IoT Core

1. Use the AWS IoT Python SDK to connect your device to AWS IoT Core.
2. Install the SDK:

   pip install AWSIoTPythonSDK
   

3. Use the following code snippet to establish a connection:

   from AWSIoTPythonSDK.MQTTLib import AWSIoTMQTTClient
   
   client = AWSIoTMQTTClient("MyClientID")
   client.configureEndpoint("YOUR_ENDPOINT", 8883)
   client.configureCredentials("YOUR_ROOT_CA_PATH", "YOUR_PRIVATE_KEY_PATH", "YOUR_CERTIFICATE_PATH")
   client.connect()
   

4. Replace YOUR_ENDPOINT, YOUR_ROOT_CA_PATH, YOUR_PRIVATE_KEY_PATH, and YOUR_CERTIFICATE_PATH with your specific configurations.

Step 4: Modify the Sample Client to Send a JSON Payload

1. Create a JSON payload that includes the telemetry data you want to send. For example:

   {
       "temperature": 25,
       "humidity": 60
   }
   

2. Publish the JSON payload to the desired topic:

   import json
   
   payload = {
       "temperature": 25,
       "humidity": 60
   }
   client.publish("your/topic", json.dumps(payload), 1)
   

Step 5: Create the Amazon Timestream Table

1. Go to the Amazon Timestream console.
2. Choose "Create database" and input a name for your database.
3. Click “Create table” and specify:
   • The name of the table.
   • The retention policies for your data.
4. Click "Create" to finalize the table setup.

Step 6: Create the AWS IoT Core Rule

1. Navigate to the AWS IoT Core console.
2. Select "Act" and then "Rules".
3. Click "Create rule" and define the rule:
   • Name your rule.
   • Set the SQL query to select data from the incoming messages.
4. Choose "Add action" and select "Write to Timestream".
5. Configure the action with your Timestream database and table.
6. Click "Create" to save the rule.

Step 7: Verify the Data in Amazon Timestream

1. Go back to the Amazon Timestream console.
2. Navigate to your created database and table.
3. Run a query to check if the data is being received correctly:

   SELECT * FROM "your_database"."your_table"
   

4. Ensure that the telemetry data is visible in the query results.

Step 8: Create the Amazon Managed Grafana Dashboard

1. Open the Amazon Managed Grafana console.
2. Choose "Create workspace" and follow the prompts to set up.
3. Once created, click on "Dashboards" and then "New dashboard".
4. Add a new panel and select Timestream as your data source.
5. Configure the panel to visualize the telemetry data from Timestream:
   • Select the database and table.
   • Choose the metrics to display.
6. Save your dashboard for future access.

Conclusion

By following these steps, you have successfully connected an IoT device to AWS IoT Core, stored data in Amazon Timestream, and visualized it in an Amazon Managed Grafana dashboard. For further exploration, consider integrating additional data sources or expanding your dashboard with more complex visualizations.