Link Search Menu Expand Document

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