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