Skip to content

Instantly share code, notes, and snippets.

@garystafford

garystafford/lorawn_iot_rule.sql

Created April 13, 2021 03:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save garystafford/e788c1e872e1f89dc2183a9757c3f50b to your computer and use it in GitHub Desktop.
Save garystafford/e788c1e872e1f89dc2183a9757c3f50b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
lorawn_iot_rule.sql
SELECT WirelessDeviceId, WirelessMetadata, "tbhv110_915" as PayloadDecoderName,
aws_lambda("arn:aws:lambda:us-east-1:111222333444:function:lorawan-iot-core-TransformLoRaWANBinaryPayloadFunc-RQOC3C6CKGWZ",
{"PayloadDecoderName": "tbhv110_915",
"PayloadData": PayloadData,
"WirelessDeviceId": WirelessDeviceId,
"WirelessMetadata": WirelessMetadata}) as PayloadData
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment