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. |