Link Search Menu Expand Document

Information schema for databases

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.

SELECT
  *
FROM
  information_schema.databases;

Columns in information_schema.databases

Each row has the following columns with information about the database.

Column Name Data Type Description
database_name TEXT The name of the database.
compressed_size BIGINT The compressed size of the database.
uncompressed_size BIGINT The uncompressed size of the database.
description TEXT The description of the database.
created_on TEXT The time the database was created.
created_by TEXT The user who created the database.
region TEXT The AWS region in which the database is configured.
attached_engines TEXT A list of engines attached to the database.
errors TEXT Not applicable for Firebolt.