Optional: review created resources

The AWS CloudFormation stack has deployed the following resources in your AWS account. Optionally you can get familiar with he created resources:

  1. A Timestream database with a name LoRaWANDatabase and tables with names LoRaWANTelemetryTable and LoRaWANMetadataTable:

    • LoRaWANTelemetryTable will store the decoded telemetry payload from LoRaWAN devices
    • LoRaWANMetadataTable will store LoRaWAN metadata (e.g. RSSI and SNR per LoRaWAN gateway) for each ingestion

    You can open the Amazon Timestream console by using this link.

  2. AWS IoT Rule WriteLoRaWANDataToTimestream_Device name and related IAM Roles and Policies.

    You can open the AWS IoT Rules console by using this link.

  3. AWS Lambda function TransformLoRaWANBinaryPayloadForTimestreamFunction and related IAM Roles and Policies.
    The Lambda function will be invoked as a part of a rule query statement of the AWS IoT Rule. It will decode a binary payload and create an output with a decoded payload in JSON. The decoded payload is to be processed by WriteLoRaWANDataToTimestreamFunction.

    You can open the AWS Lambda console by using this link. You can find a source code of this Lambda function on GitHub by using this link.

  4. AWS Lambda function WriteLoRaWANDataToTimestreamFunction and related IAM Roles and Policies.
    This function write the decoded payload attributes as measures into the Timestream table LoRaWANTelemetryTable. Additionally this function will write LoRaWAN metadata (e.g. RSSI and SNR per LoRaWAN gateway) into the Timestream table LoRaWANMetadataTable. To load payload decoders, this function will include AWS Lambda layer LoRaWANPayloadDecoderLayer.

    You can open the AWS Lambda console by using this link. You can find a source code of this Lambda function on GitHub by using this link.

  5. EC2 instance with Grafana pre-configured to access the Amazon Timestream data source

    You can open the AWS Lambda console by using this link. You can connect to the instance via Session Manager by clicking on the “Connect” button.

The CloudFormation stack in this sample prepends a stack name to the name of the above mentioned resources. For example if you use the lorawanworkshop as a stack name, the name of Timestream database will be lorawanworkshopLoRaWANDatabase and the name of AWS IoT Rule will be lorawanworkshopStoreLoRaWANDataInTimestream.