Link Search Menu Expand Document

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

  • 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;