generate messages to kafka topic, connect it to clickhouse as the real-time db, do a light transformation, and have superset read the table from clickhouse and display charts