Much bigger fan of the approach described here:
Scalability, Allocation, and Processing of Data for Multitenancy
https://stratoflow.com/data-scalability-allocation-processin...