engines:alter_pool
rai engines:alter_pool [OPTIONS]Alters the engine pool size limits for your Snowflake account by engine size.
Requires the eng_admin application role. Supported on the Snowflake platform only.
Options
Section titled “Options”| Option | Type | Description |
|---|---|---|
--size | Text | The engine size to configure. If omitted, you are prompted to select a size interactively. Sizes depend on your account and cloud provider and include HIGHMEM_X64_S, HIGHMEM_X64_M, HIGHMEM_X64_L. See Engine Sizes. |
--min | Integer | Minimum number of engines to keep available for the chosen size (non‑negative). If omitted, you are prompted to enter a value interactively. |
--max | Integer | Maximum number of engines allowed for the chosen size. Must be greater than or equal to --min. If omitted, you are prompted to enter a value interactively. |
Example
Section titled “Example”Set the pool limits for small engines so that at least 2 are available (warm) and autoscaling can grow the pool up to 5:
$ rai engines:alter_pool --size HIGHMEM_X64_S --min 2 --max 5
---------------------------------------------------
▰▰▰▰ Engine pool altered
---------------------------------------------------You can also run the command without options and choose the size and limits interactively:
$ rai engines:alter_pool# Select engine size: HIGHMEM_X64_S# Enter minimum number of engines: 3# Enter maximum number of engines: 8See the Managing Compute Resources guide for more information about engine sizes and engine pools.