TimeStream_Grafana_SetUp.md

Follow this link to set up Grafana cloud https://grafana.com/

Table of Content

• Create Rule In AWS IoT Core
• Create The TimeStream Database
• Create a Table In The TimeStream Database
• Finishing With the Rule
• Creating New User For Acessing the Timestream Database Through Graphana
• Connecting Graphana to Timestream Database
• Representing the Data

Create Rule In AWS IoT Core

If you have followed the official tutorial by AWS on how to set up IoT Core with python the exact same steps as shown in the pictures can be followed.

Create The TimeStream Database

Create a Table In The TimeStream Database

Finishing With the Rule

Creating New User For Acessing the Timestream Database Through Graphana

The Credinentials as shown in the below pictrure will be used to in Graphana to establish a connection with the TimeStream Database

Connecting Graphana to Timestream Database

Representing the Data

Create a time series dash board and add the following queries

SELECT CREATE_TIME_SERIES(time,measure_value::bigint) as humidity FROM "timestream8"."weatherData" where time BETWEEN from_milliseconds(1660398638031) AND from_milliseconds(1660400138031) and measure_name = 'humidity'

SELECT CREATE_TIME_SERIES(time,measure_value::bigint) as temperature
FROM "timestream8"."weatherData" where time BETWEEN from_milliseconds(1660398638031) AND from_milliseconds(1660400138031) and measure_name = 'temperature'