Snowflake DBA

Virtual Warehouses & Compute

Question

Scaling up vs. scaling out: what does each add, and when should each be used?

Answer

Scaling up increases resources within each cluster, helping an individual resource-heavy query. Scaling out adds clusters, helping independent concurrent queries. Scale up for spills or long scans; scale out for sustained queueing from concurrency.

This is 5 of 21 free samples for Snowflake DBA.

More Snowflake DBA topic samples