PROJECT_OPTIONS view

You can query theINFORMATION_SCHEMA.PROJECT_OPTIONS view to retrievereal-time metadata about BigQuery project options. This view containsconfiguration options that have been set at the project level. To view thedefault values for a configuration option, seeconfigurationsettings.

Required permissions

To get configuration options metadata, you need the following Identity and Access Management (IAM) permissions:

• bigquery.config.get

The following predefined IAM role includes thepermissions that you need in order to get project options metadata:

• roles/bigquery.jobUser

For more information about granular BigQuery permissions, seeroles and permissions.

Schema

When you query theINFORMATION_SCHEMA.PROJECT_OPTIONS view, the query results containone row for each configuration option in a project that differs from the default value.

TheINFORMATION_SCHEMA.PROJECT_OPTIONS view has the following schema:

Options table

For stability, we recommend that you explicitly list columns in your information schema queries instead ofusing a wildcard (SELECT *). Explicitly listing columns prevents queries frombreaking if the underlying schema changes.

Data retention

This view contains currently running sessions and the history of sessions completed in the past 180 days.

Scope and syntax

Queries against this view must have aregion qualifier.

Replace the following:

• REGION: anydataset region name. For example,region-us.

Examples

The following example retrieves theOPTION_NAME,OPTION_TYPE, andOPTION_VALUE columns from theINFORMATION_SCHEMA.PROJECT_OPTIONS view.

SELECToption_name,option_type,option_valueFROM`region-REGION`.INFORMATION_SCHEMA.PROJECT_OPTIONS;

  +--------------------------------------------+-------------+---------------------+  | option_name                                | option_type | option_value        |  +--------------------------------------------+-------------+---------------------+  | default_time_zone                          | STRING      | America/Los_Angeles |  +--------------------------------------------+-------------+---------------------+  | default_kms_key_name                       | STRING      | test/testkey1       |  +--------------------------------------------+-------------+---------------------+  | default_query_job_timeout_ms               | INT64       | 18000000            |  +--------------------------------------------+-------------+---------------------+  | default_interactive_query_queue_timeout_ms | INT64       | 600000              |  +--------------------------------------------+-------------+---------------------+  | default_batch_query_queue_timeout_ms       | INT64       | 1200000             |  +--------------------------------------------+-------------+---------------------+