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
appuser, and can be raised to 200.