This paper explains design patterns for multi-tenant applications on Snowflake. It compares Multi-Tenant Table (MTT), Object Per Tenant (OPT), and Account Per Tenant (APT) models. MTT shares tables across tenants with tenant IDs, offering scalability but less isolation. OPT uses separate schemas for each tenant, allowing customization and clearer cost tracking. APT gives each tenant a separate account, maximizing security and autonomy. Compute can be shared or isolated. Best practices include using secure views, RBAC, automation for provisioning, and query tags for cost tracking. Hybrid approaches mix models to balance cost, performance, and security.

Join for free to read