Good day! We are considering use Clickhouse as logs storage. Logs are collected via different kafka topics (kafka engine). Does CH have engine (solution) to enrich logs with each other?
For example, we have this data:
| Event | TransactionalId | CustomerId | SenderIp |
|---|---|---|---|
| Process from inbound topic | 2882744823229624342 | 175641 | NULL |
| Process from IP topic | 2882744823229624342 | NULL | 1.1.1.1 |