Comment by manigandham

You don't need to add new columns.

   CREATE TABLE metrics (metric_name text, ts timestamp, properties json, key(metric_name, ts))

OLAP queries with SQL are very good at handling whatever dimensions you want.