Every change here is an update to the warehouse, which is modifying until it’s done. In the console,
use the warehouse’s Configuration tab.
Add replicas
ezgh warehouse warehouses update whs_4k2m9x0a7qpe --replicas 3 --waitEvery shard gets the new replicas, which copy the shard’s tables and data from the existing ones. The update is done once they’ve caught up.
Add shards
ezgh warehouse warehouses update whs_4k2m9x0a7qpe --shards 4 --waitExisting data stays on the current shards. Rows inserted through a Distributed table spread across all shards by its sharding key. The new shards get every database and table. See Sharding.
Keeper mode
ezgh warehouse warehouses update whs_4k2m9x0a7qpe --keeper colocated --waitA warehouse with 3 or more nodes whose instance type has at least 8 vCPUs and 32 GiB of memory, and isn’t a shared vCPU type
(gs-1), can use colocated; otherwise a warehouse with more than one node is dedicated. A change to a smaller instance type that’s below that while
colocated is refused with 409 keeper_colocation_needs_larger_nodes, and one to a shared vCPU type with
400 invalid_request: switch to dedicated first. See
Keeper mode.
Change the size
ezgh warehouse warehouses update whs_4k2m9x0a7qpe --instance-type gp-1.xlarge --waitThe warehouse moves one replica of each shard at a time.
Grow storage
ezgh warehouse warehouses update whs_4k2m9x0a7qpe --storage-size-gib 1000 --waitEvery node’s storage grows while it serves.