INFORMATION_SCHEMA is a series of views that provide access to metadata
about datasets, tables, and views.

You can query the INFORMATION_SCHEMA.VIEWS view to retrieve metadata about
views in a dataset.

Required permissions

To get information about views, you must be assigned the
READER role on the
dataset, or you must be assigned a project-level IAM role that
includes bigquery.tables.get permissions. If you are granted
bigquery.tables.get permissions at the project level, you can get information
about all views in the project. All predefined, project-level IAM roles include
bigquery.tables.get permissions except forbigquery.jobUser and
bigquery.user.

In addition, a user assigned the bigquery.user role has
bigquery.datasets.create permissions. This allows a user assigned to the
bigquery.user role to get information about views in any dataset that user
creates. When a user assigned to the bigquery.user role creates a dataset,
that user is given OWNER access to the dataset. OWNER access to a dataset
gives the user full control over it and all the views in it.

YES if the view was created by using a standard SQL query; NO if useLegacySql is set to true

Examples

Example 1:

The following example retrieves all columns from the INFORMATION_SCHEMA.VIEWS
view except for check_option which is reserved for future use. The metadata
returned is for all views in mydataset in your default project — myproject.

Queries against the INFORMATION_SCHEMA.VIEWS view must have a dataset
qualifier. The user submitting the query must have access to the dataset that
contains the views.

To run the query against a project other than your default project, add the
project ID to the dataset in the following format:
`[PROJECT_ID]`.[DATASET].INFORMATION_SCHEMA.[VIEW] for
example, `myproject`.mydataset.INFORMATION_SCHEMA.VIEWS.

Note that the results show that this view was created by using a legacy SQL query.

Example 2:

The following example retrieves the SQL query and query syntax used to define
myview in mydataset in your default project — myproject.

Queries against the INFORMATION_SCHEMA.VIEWS view must have a dataset
qualifier. The user submitting the query must have access to the dataset that
contains the views.

To run the query against a project other than your default project, add the
project ID to the dataset in the following format:
`[PROJECT_ID]`.[DATASET].INFORMATION_SCHEMA.[VIEW] for
example, `myproject`.mydataset.INFORMATION_SCHEMA.VIEWS.