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 STRING The name of the database.
region STRING The AWS Region in which the database was created.
attached_engines STRING 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 STRING The user name of the Firebolt user who created the database.
errors STRING Any error messages associated with the database.