Skip to content

Limits

Warehouse shapes, query editor limits and Service quotas.

Updated View as Markdown

Shape

Shards 1 to 8
Replicas per shard 1 to 3
Instance type At least 8 GiB of memory; the same for every node
Shared vCPU instance types gs-1.2xlarge (8 vCPUs, 16 GiB) and gs-1.4xlarge (16 vCPUs, 32 GiB)
colocated Keeper 3 or more nodes, with at least 8 vCPUs and 32 GiB of memory each; not on shared vCPU instance types
Backup retention 1 to 35 days

Query editor

Results 10,000 rows or 16 MiB
Time 5 minutes per query

Quotas

Service quotas for Warehouse:

Quota ID Kind Scope Default
Warehouses per project warehouse.warehousesPerProject Allocation Per project 5 warehouses
Nodes per warehouse warehouse.nodesPerWarehouse Allocation Per warehouse 24 nodes
Users per warehouse warehouse.usersPerWarehouse Allocation Per warehouse 50 users
Connections per warehouse warehouse.connectionsPerWarehouse Allocation Per warehouse 20 connections
  • Warehouses per project counts warehouses in any state, and can be raised to 40. Nodes per warehouse counts shards × replicas. Users per warehouse counts the app user, and can be raised to 200.
Navigation

Type to search…

↑↓ navigate↵ selectEsc close