This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.
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 | TEXT | The name of the engine. |
| region | TEXT | The AWS Region in which the engine was created. |
| spec | TEXT | The specification of nodes comprising the engine. |
| scale | INTEGER | The number of nodes in the engine. |
| status | TEXT | The engine status. For more information, see Viewing and understanding engine status. |
| attached_to | TEXT | The name of the database to which the engine is attached. |
| version | TEXT | The engine version. |