Snowflake Account & Warehouse Architecture
The structural decisions that determine whether an account stays manageable at scale: database and schema layout, naming conventions, and a warehouse strategy that separates workloads before they start competing for the same compute.
- Database, schema and role hierarchy with least-privilege grants mapped to real job functions
- Separate virtual warehouses per workload, with auto-suspend and sizing tuned against actual query profiles
- Naming and tagging conventions that keep a growing account navigable, not just a working one