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}"