Link Search Menu Expand Document

CREATE ENGINE

Creates an engine (compute cluster).

Syntax

CREATE ENGINE [IF NOT EXISTS] <engine_name>
[WITH <properties>]

Where <properties> are:

  • REGION = '<aws_region>'
  • ENGINE_TYPE = <type>
  • SPEC = '<spec>'
  • SCALE = <scale>
  • AUTO_STOP = <minutes>
  • WARMUP = [ MINIMAL | PRELOAD_INDEXES | PRELOAD_ALL_DATA ]
Parameter Description Mandatory? Y/N
<engine_name> An identifier that specifies the name of the engine.

For example: my_engine
Y
REGION = '<aws_region>' The AWS region in which the engine runs.

If not specified, 'us-west-2' is used as default.
N
ENGINE_TYPE = <type> The engine type. The <type> can have one of the following values: 1. GENERAL_PURPOSE

2. DATA_ANALYTICS

If not specified - GENERAL_PURPOSE is used as default.

Usage example:

CREATE ENGINE ... ENGINE_TYPE = GENERAL_PURPOSE
N
SPEC = '<spec>' The Firebolt engine spec, for example, 'M8'.

If not specified, 'S8' is used as default.
N
SCALE =
<scale>
Specifies the scale of the engine.

The scale can be any INT between 1 to 128.

If not specified, 2 is used as default.
N
AUTO_STOP = <minutes> Indicates the amount of time (in minutes) after which the engine automatically stops. The default value is 20.

Setting the minutes to 0 indicates that AUTO_STOP is disabled.
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–create an engine with (non-default) properties

CREATE ENGINE my_engine
WITH SPEC = 'S24E' SCALE = 8