Link Search Menu Expand Document

CREATE ENGINE

Creates an engine (compute cluster).

Syntax

CREATE ENGINE [IF NOT EXISTS] <engine_name>
[WITH <property> = <value> ...]

The following table describes properties and their values.

Property Description
REGION = '<aws_region>' The AWS region in which the engine will run. After engine is created, its region cannot be changed. An engine must be in the same region as the database it will be attached to.

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

1. GENERAL_PURPOSE - can do everything analytics engines do, but can also write data to Firebolt tables. General purpose engines are designed for database creation, data ingestion, and extract, load, and transform (ELT) operations. A database can have only one general purpose engine running at a time.
2. DATA_ANALYTICS - are read-only and cannot be used to add, delete or change data in Firebolt tables. You can run as many analytics engines as you need at the same time.

If not specified - GENERAL_PURPOSE is used as default.

SPEC = '<spec>' The engine spec defines engine’s compute capabilities. Each engine spec has CPU, RAM, and cache characteristics. The engine spec determines the cost per hour (billed per second) for each engine node (the total engine cost per hour is also a function of scale). You can choose engine specs for characteristics that are best suited for your Firebolt workload. For details, see Available engine specs.

If not specified, 'S8' is used as default.
SCALE =<scale> Scale determines the number of nodes that the engine uses and can be an integer ranging from 1 to 128. Firebolt monitors the health of nodes on a continuous basis and automatically repairs nodes that report an unhealthy status.

If not specified, 2 is used as default.
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.
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).

Example–create an engine

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