Model based on organizational grouping and precisely-configured Virtual Warehouses

If logical organizational grouping and also precisely configured Virtual Warehouses are your driving factors then you should model based on them.

For each tenant, you can create multiple Virtual Warehouses dedicated to that tenant, and each Virtual Warehouse can be configured specifically for a given workload pattern. The benefit is that you get logical organizational grouping and also precisely configured Virtual Warehouses. The downside is that this results in more Virtual Warehouses to manage and more “always-on” overhead costs.