Users on db console should be able to view tenant-separated metrics. To make this possible, we need to change the way we store the metrics in tsdb to include tenant information. On the query side, tsdb should be able to fetch these tenant-separated metrics for a tenant. The desired behavior here is that the system tenant, by default, views metrics for all tenants, while an application tenant can only view metrics for itself.

Jira issue: CRDB-24125

Epic CRDB-18798