Working with engines using DDL
You can use SQL statements to execute the operations listed in this topic.
- To list (SHOW) all engines in your Firebolt account
- To start an engine
- To stop an engine
- To create an engine
- To attach an engine to a database
- To edit (ALTER) an engine
- To delete (DROP) an engine
To list (SHOW) all engines in your Firebolt account
- Using a running engine, execute the
SHOW ENGINES
statement as shown in the example below.SHOW ENGINES;
The statement returns a list of engines by name, including the region, engine specification, scale, status, and attached database.
To start an engine
- Using a running engine, execute a
START ENGINE
statement similar to the example below.START ENGINE MyDatabase_MyFireboltEngine
To stop an engine
- Execute a
STOP ENGINE
command using a running engine similar to the example below. You can use the same engine that you are stopping.STOP ENGINE MyDatabase_MyFireboltEngine
To create an engine
- Using a running engine, execute a
CREATE ENGINE
statement similar to one of the examples below. For more information, see CREATE ENGINE.
Example – Create engine using default values
CREATE ENGINE MyDatabase_MyFireboltEngine;
GENERAL_PURPOSE
is the default engine type if none is specified.
Example – Create an analytics engine, specifying all properties
CREATE ENGINE MyDatabase_MyFireboltEngine WITH
REGION = 'us-west-2'
ENGINE_TYPE = DATA_ANALYTICS
SCALE = 32
SPEC = 'S8'
AUTO_STOP = '45'
WARMUP = PRELOAD_ALL_DATA;
To attach an engine to a database
This action is available only using DDL.
- Using a running engine, execute an
ATTACH ENGINE
statement similar to the example below.ATTACH ENGINE MyDatabase_MyFireboltEngine TO MyDatabase;
To edit (ALTER) an engine
- Using a running engine, execute an
ALTER ENGINE
statement similar to the example below.ALTER ENGINE MyDatabase_MyFireboltEngine SET SCALE = 12 SPEC = 'S8' AUTO_STOP = '45' RENAME TO 'MyProductionDatabase_MyFireboltEngine' WARMUP = PRELOAD_ALL_DATA;
To delete (DROP) an engine
- Using a running engine, execute a
DROP ENGINE
SQL statement similar to the example below.DROP ENGINE MyDatabase_MyFireboltEngine;