Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@garystafford

garystafford/iot_rule.sql

Last active August 27, 2020 17:38
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/ef632dd00f72d8b82efd1177479816eb to your computer and use it in GitHub Desktop.
Save garystafford/ef632dd00f72d8b82efd1177479816eb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
iot_rule.sql
SELECT
data.device_id,
data.gateway_id,
data.temperature,
data.humidity,
data.pressure,
data.color.red,
data.color.green,
data.color.blue,
data.color.ambient,
ts,
Clientid () AS device,
parse_time ("yyyy-MM-dd'T'HH:mm:ss.SSSZ", timestamp(), "UTC") AS msg_received
FROM
"${IoTTopicName}"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment