Case Study

DESIGN PATTERNS FOR BUILDING MULTI-TENANT APPLICATIONS ON SNOWFLAKE

DESIGN PATTERNS FOR BUILDING MULTI-TENANT APPLICATIONS ON SNOWFLAKE

Pages 26 Pages

WHITE PAPER DESIGN PATTERNS FOR BUILDING MUL TI-TENANT APPLICATIONS ON SNOWFLAKEWHITE PAPER 1 Introduction 2 Part One: Comparing Multi-Tenant Design Patterns 5 Part Two: Exploring Each Design Pattern 5 MTT design notes 14 OPT design notes 18 APT design notes 21 Part Three: Evaluating Tenancy Models 21 Storage and security considerations 22 Encryption, isolation, and data protection considerations 23 Billing, resource utilization, and network policy considerations 24 About Snowflake WHITE PAPER 1 Introduction Multi-tenant Snowflake applications typically conform to one of three design patterns: • Multi-tenant table (MTT): MTT consolidates tenants within a shared table or warehouse. Centralizing tenants in single, shared objects enables tenants to share compute and other resourc

Join for free to read