I saw the same video, and had the same thoughts. I saw a comment mentioning flashing the Emporia with ESPHOME, of which I am a great fan. What I really like about that option is you can push all the logic to the "edge" device with ease (including hosting a webserver), or just merely expose the data and use e.g homeassistant to manage it. I'm sure you could probably also have it post the data directly to clickhouse if you want. All this to say esphome is really great and I love its flexibility.