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