> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/commands/metadata/show-engines",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference and syntax for the SHOW ENGINES command.

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

For more information regarding engines, see [information\_schema.engines](/reference-sql/information-schema/engines).

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SHOW ENGINES;
```

## Returns

The returned table has the following columns.

| Column Name        | Data Type   | Description                                                                                                                                                    |
| :----------------- | :---------- | :------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| engine\_name       | TEXT        | The name of the engine.                                                                                                                                        |
| engine\_owner      | TEXT        | The name of the user who created the engine.                                                                                                                   |
| type               | TEXT        | Determines the capability of the nodes in the engine.                                                                                                          |
| family             | TEXT        | The family of a given engine. Choose from `STORAGE_OPTIMIZED` or `COMPUTE_OPTIMIZED`.                                                                          |
| nodes              | INTEGER     | The number of nodes in a cluster.                                                                                                                              |
| clusters           | INTEGER     | The number of node groupings in an engine.                                                                                                                     |
| status             | TEXT        | The engine status. For more information, see [Viewing and understanding engine status](/overview/engine-fundamentals#viewing-and-understanding-engine-status). |
| auto\_start        | BOOLEAN     | When true, queries issued to a stopped engine will attempt to start the engine first.                                                                          |
| auto\_stop         | INTEGER     | Indicates the amount of time (in minutes) after which the engine automatically stops.                                                                          |
| initially\_stopped | BOOLEAN     | When true, the engine will have attempted to start after creation.                                                                                             |
| url                | TEXT        | A url which can be used to issue queries to this engine.                                                                                                       |
| default\_database  | TEXT        | The database an engine will attempt to use by default when dealing with queries that require a database.                                                       |
| version            | TEXT        | The engine version.                                                                                                                                            |
| last\_started      | TIMESTAMPTZ | The last time this engine was started (UTC).                                                                                                                   |
| last\_stopped      | TIMESTAMPTZ | The last time this engine was stopped (UTC).                                                                                                                   |
| description        | TEXT        | A user defined description for the engine.                                                                                                                     |
| fbu\_rate          | NUMERIC     | Hourly FBU consumption rate of engines based on engine topology at the time the view is invoked by the user.                                                   |
| release\_channel   | TEXT        | The release channel.                                                                                                                                           |