← Back to Snowflake
1

Design a Virtual Warehouse Architecture

System DesignhardCommon
virtual-warehouseauto-scalingmulti-tenantcompute

Reported

9 times

Last seen

2026-03-24

First seen

2025-06-20

Active in

2025, 2026

Description

Design a compute layer that provides isolated virtual warehouses with auto-scaling, suspend/resume, and resource sharing.

Approach Tips

Discuss compute-storage separation. Cover auto-suspend after idle timeout, instant resume with cached state, and how to prevent noisy neighbor issues.

Sources

Blind·SDE-3·2026-03-24
Glassdoor·Staff·2025-12-15
SF

Snowflake

Data/Cloud

Typically appears in: Onsite - System Design

60 min — Design a cloud data platform component. Focus on scalability, multi-tenancy, and query performance.