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