Link Search Menu Expand Document

SHOW ENGINES

Returns a table with a row for each Firebolt engine defined in the current Firebolt account, with columns containing information about each engine as listed below.

Syntax

SHOW ENGINES;

Returns

The returned table has the following columns.

Column name Data Type Description
engine_name STRING The name of the engine.
region STRING The AWS Region in which the engine was created.
spec STRING The specification of nodes comprising the engine.
scale INT The number of nodes in the engine.
status STRING The engine status. For more information, see Viewing and understanding engine status.
attached_to STRING The name of the database to which the engine is attached.
version STRING The engine version.