| 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