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.

Syntax

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

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Returns

​Syntax

​Returns

Syntax

Returns