Multi-tenant warehouse isolation

DesignHard40 minSnowflake and Databricks style

Your task

You run an embedded-analytics product where thousands of your customers query their own data in a shared cloud warehouse. One customer's heavy ad-hoc query or a runaway dashboard can saturate compute and slow everyone (noisy neighbor); customers also demand strict data isolation and per-tenant cost attribution for billing. Design the warehouse architecture covering tenant isolation, query resource governance, and accurate per-tenant cost accounting, and discuss the isolation-vs-efficiency trade-off.

It covers

  • Multi tenant
  • Cost isolation
  • Noisy neighbor