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 supports information_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.
- Accounts
- Applicable roles
- Catalogs
- Columns
- Engine history
- Engine metering history
- Engine metrics history
- Engine query history
- Engine running queries
- Engine user query history
- Engines
- Engines Billing
- Indexes
- Logins
- Network policies
- Object privileges
- Schemata
- Service accounts
- Storage Billing
- Storage Metering History
- Storage history
- Tables
- Transitive applicable roles
- Users
- Views