> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

# BigQuery information_schema

> The BigQuery-shaped information_schema views available under dialect=bigquery.

Under [dialect=bigquery](/reference-sql/bigquery/overview), a supported view follows [BigQuery's `INFORMATION_SCHEMA`](https://docs.cloud.google.com/bigquery/docs/information-schema-intro): its column names, order, and data types.

## Supported views

* `information_schema.tables` ([BigQuery reference](https://docs.cloud.google.com/bigquery/docs/information-schema-tables)).
* `information_schema.columns` ([BigQuery reference](https://docs.cloud.google.com/bigquery/docs/information-schema-columns)).
* `information_schema.jobs` / `jobs_by_user` / `jobs_by_project` ([BigQuery reference](https://docs.cloud.google.com/bigquery/docs/information-schema-jobs)). Region-qualified; see below.
* `information_schema.views` ([BigQuery reference](https://docs.cloud.google.com/bigquery/docs/information-schema-views)).
* `information_schema.schemata` ([BigQuery reference](https://docs.cloud.google.com/bigquery/docs/information-schema-datasets-schemata)).
* `information_schema.routines` ([BigQuery reference](https://docs.cloud.google.com/bigquery/docs/information-schema-routines)).
* `information_schema.object_privileges` ([BigQuery reference](https://docs.cloud.google.com/bigquery/docs/information-schema-object-privileges)).
* `information_schema.search_indexes` ([BigQuery reference](https://docs.cloud.google.com/bigquery/docs/information-schema-indexes)).
* `information_schema.vector_indexes` ([BigQuery reference](https://docs.cloud.google.com/bigquery/docs/information-schema-vector-indexes)).

Any `INFORMATION_SCHEMA` view not listed does not exist in BigQuery mode: querying it raises a "relation does not exist" error.

## Addressing

A supported view is reachable by the BigQuery dataset-qualified forms as well as the bare form:

* `INFORMATION_SCHEMA.TABLES`: the current database, all datasets.
* `<dataset>.INFORMATION_SCHEMA.TABLES`: one dataset (`table_schema = '<dataset>'`).
* `<project>.<dataset>.INFORMATION_SCHEMA.TABLES`: `<project>` selects the database, `<dataset>` the schema.

Region-qualified forms (`` `region-us`.INFORMATION_SCHEMA.* ``) are rejected for dataset-scoped views. The JOBS family is region-scoped in BigQuery (`` `region-us`.INFORMATION_SCHEMA.JOBS ``); Firebolt has no regions, so the region qualifier is accepted and ignored, and the bare form works too.

## Notes

* Type-valued columns carry Firebolt spellings, not BigQuery's: `tables.ddl` returns Firebolt DDL, `columns.data_type` returns Firebolt type names (`BIGINT`, `TEXT`), `views.view_definition` returns Firebolt DDL, and `tables.table_type` may carry Firebolt-specific values (for example `EXTERNAL`) for objects with no BigQuery equivalent.
* `pg_catalog` has no BigQuery equivalent and is not available in BigQuery mode; referencing it raises a "relation does not exist" error.