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. |
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. |
Example
The following example shows information about databases in the account:
SHOW DATABASES;
database_name | compressed_size | uncompressed_size | description | created_on | created_by | region | attached_engines | errors |
---|---|---|---|---|---|---|---|---|
AdTechDB_v4 | NULL | NULL | New Demo DB | 2022-06-15T11:48:31.683328Z | firebolt-demo | SA Demo us-east-1 | NULL | NULL |