You can use the
information_schema.databases view to return information about databases. You can use a
SELECT query to return information about each database as shown in the example below.
Each row has the following columns with information about the database.
|The name of the database.
|The compressed size of the database.
|The uncompressed size of the database.
|The description of the database.
|The time the database was created.
|The user who created the database.
|The AWS region in which the database is configured.
|A list of engines attached to the database.
|Not applicable for Firebolt.