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
- Example – Create engine using default values
- Example – Create an analytics engine, specifying all properties
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;
```