INFORMATION_SCHEMA is a series of views that provide access to:
For projects that use on-demand pricing, queries against
views incur a minimum of 10 MB of data processing charges, even if the bytes
processed by the query are less than 10 MB. 10 MB is the minimum billing amount
for on-demand queries. For more information, see
For projects that use flat-rate pricing, queries against
views and tables consume your purchased BigQuery slots. For more
information, see Flat-rate pricing.
INFORMATION_SCHEMA queries are not cached, you are charged each time
you run an
INFORMATION_SCHEMA query, even if the query text is the same each
time you run it.
You are not charged storage fees for the
With the exception of
INFORMATION_SCHEMA views must have a dataset specifier.
-- Returns metadata for tables in a single dataset. SELECT * FROM myDataset.INFORMATION_SCHEMA.TABLES;
To get metadata from a different project, prepend the project ID to the view.
SELECT * FROM myOtherProject.myDataset.INFORMATION_SCHEMA.TABLES;
INFORMATION_SCHEMA is subject to the following
INFORMATION_SCHEMAqueries must be in standard SQL syntax.
INFORMATION_SCHEMAdoes not support legacy SQL.
INFORMATION_SCHEMAquery results are not cached.
INFORMATION_SCHEMAcannot be used to retrieve metadata on partitions in partitioned tables.
INFORMATION_SCHEMAviews cannot be used in DDL statements.