Creates an engine (compute cluster).
CREATE ENGINE [IF NOT EXISTS] <engine_name> [WITH [ENGINE_TYPE = <type>] [SCALE = <scale>] [SPEC = <spec>] [AUTO_STOP = <minutes] [WARMUP = <warmup_method>]]
| ||The engine type can have one of the following values: |
If not specified -
| ||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.
| ||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,
| ||Indicates the amount of time (in minutes) after which the engine automatically stops. The default value is 20. |
| ||The warmup method that should be used. The following options are supported: |
The following example creates an engine with a scale of
CREATE ENGINE my_engine WITH SCALE = 8