ALTER ENGINE
Updates the configuration of the specified engine <engine_name>
.
Syntax
ALTER ENGINE <engine_name> SET
[SCALE = <scale>]
[SPEC = <spec>]
[AUTO_STOP = <minutes]
[RENAME TO <new_name>]
[WARMUP = <warmup_method>]
Parameter | Description | Mandatory? Y/N |
---|---|---|
<engine_name> | Name of the engine to be altered. | Y |
SCALE = <scale> | Valid scale numbers include any INT between 1 to 128. | N |
SPEC = <spec> | Indicates the Firebolt engine spec, for example, M8 . | N |
AUTO_STOP = <minutes> | The number of minutes after which the engine automatically stops, where 0 indicates that AUTO_STOP is disabled. | N |
RENAME TO <new_name> | Indicates the new name for the engine. For example: RENAME TO new_engine_name | N |
WARMUP =<warmup_method> | The warmup method that should be used, the following options are supported:MINIMAL On-demand loading (both indexes and tables’ data).PRELOAD_INDEXES Load indexes only (default).PRELOAD_ALL_DATA Full data auto-load (both indexes and table data - full warmup). | N |
Example–change engine scale
ALTER ENGINE my_engine SET SCALE TO 1