What does your schema for metrics look like? Using materialised views? I am particularly interested in storing metrics with labels(key/val pairs) Eg, Prometheus metrics. You can't flatten them out into columns due to high dimensionality(can need millions of columns). Do you store the labels in an array?
Not the person you're replying to, but you can see how SigNoz did it here [1]
Essentially you add: keys Array(String), values Array(String) and write the pairs accordingly.