Link Search Menu Expand Document

SHOW DATABASES

Returns a table with a row for each database defined in the current Firebolt account, with columns containing information as listed below.

Syntax

SHOW DATABASES;

Returns

The returned table has the following columns.

Column name Data Type Description
database_name TEXT The name of the database.
region TEXT The AWS Region in which the database was created.
attached_engines TEXT A comma separated list of engine names that are attached to the database.
created_on TIMESTAMP The date and time that the database was created (UTC).
created_by TEXT The user name of the Firebolt user who created the database.
errors TEXT Any error messages associated with the database.