Snowflake Multi-Environment Setup Overview Configure dev/staging/production environments using Snowflake's zero-copy cloning, separate databases, and environment-specific roles and warehouses. Environment Strategy | Environment | Approach | Data | Warehouse | Cost | |-------------|----------|------|-----------|------| | Development | Cloned DB, XSMALL WH | Zero-copy clone (refreshed weekly) | DEV WH XS | Minimal | | Staging | Cloned DB, same-size WH | Zero-copy clone (refreshed daily) | STAGING WH | Moderate | | Production | Source of truth | Real data | PROD WH (multi-cluster) | Full | Instr…