So the workload is pretty OLAP, we’re storing payment events and then aggregating it to monthly/daily based on a model.
> From what I know about it, it should be not the case.
I understood that it was possible to setup connection access (this) but not sure how to move to a more native CH storage (which i think is the good long term solution)
is this https://clickhouse.com/blog/working-with-time-series-data-and-functions-ClickHouse the post you mean?
