Skip to main content
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 NameData TypeDescription
engine_nameTEXTThe name of the engine.
engine_ownerTEXTThe name of the user who created the engine.
typeTEXTDetermines the capability of the nodes in the engine.
familyTEXTThe family of a given engine. Choose from STORAGE_OPTIMIZED or COMPUTE_OPTIMIZED.
nodesINTEGERThe number of nodes in a cluster.
clustersINTEGERThe number of node groupings in an engine.
statusTEXTThe engine status. For more information, see Viewing and understanding engine status.
auto_startBOOLEANWhen true, queries issued to a stopped engine will attempt to start the engine first.
auto_stopINTEGERIndicates the amount of time (in minutes) after which the engine automatically stops.
initially_stoppedBOOLEANWhen true, the engine will have attempted to start after creation.
urlTEXTA url which can be used to issue queries to this engine.
default_databaseTEXTThe database an engine will attempt to use by default when dealing with queries that require a database.
versionTEXTThe engine version.
last_startedTIMESTAMPTZThe last time this engine was started (UTC).
last_stoppedTIMESTAMPTZThe last time this engine was stopped (UTC).
descriptionTEXTA user defined description for the engine.
fbu_rateNUMERICHourly FBU consumption rate of engines based on engine topology at the time the view is invoked by the user.
release_channelTEXTThe release channel.