Information Schema Views
The Firebolt information schema consists of a set of system views that contain metadata information on the objects defined in the current account, as well as database usage views. Firebolt supportsinformation_schema schema based on ANSI SQL standard, but extended with Firebolt specific information, both as additional columns in standard views, and as additional views.
For better compatibility with applications that rely on Postgres specific system views, Firebolt also supports pg_catalog schema and subset of Postgres compatible views in it.
Available Information Schema Views
Firebolt provides the following information schema views:Database Objects
- catalogs - Available databases
- schemata - Database schemas
- tables - Tables in the database
- views - Views in the database
- columns - Columns in tables
- indexes - Indexes for tables
- routines - SQL functions
- locations - Connection details and credentials for external data sources
Account and Organization
- accounts - Accounts in the organization
- organization - Organization-level information
Security and Access Control
- applicable_roles - Roles applicable to the current user
- enabled_roles - Currently enabled roles for the session
- transitive_applicable_roles - All roles transitively applicable to the current user
- logins - Logins in organization
- users - Users in current account
- service_accounts - Service accounts in organization
- network_policies - Network access policies
- object_privileges - Privileges granted on database objects
- object_default_privileges - Default privileges for database objects
Engine Management
- engines - Available engines and their configurations
- engine_history - Historical engine state changes
- engine_caches - Engine cache information
Query Monitoring
- engine_query_history - Historical query execution data
- engine_user_query_history - User-specific query history
- engine_running_queries - Currently executing queries
- transactions - Active and historical transactions
Billing and Usage
- engines_billing - Engine billing information
- engine_metering_history - Engine usage metering data
- engine_metrics_history - Historical engine performance metrics
- storage_billing - Storage billing information
- storage_history - Historical storage usage
- storage_metering_history - Storage metering data
Resource Management
- quotas - Resource quotas and limits
engine_metrics_historyengine_running_queriesengine_query_historyengine_user_query_history