EFFECTIVE_PROJECT_OPTIONS view
You can query theINFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS view toretrieve real-time metadata about BigQuery effective project options.This view contains configuration options that are set at the organization orproject level. If the same configuration option is set at both the organizationand project level, the project configuration value is shown. To view the defaultvalues for a configuration option, seeconfigurationsettings.
Required permissions
To get effective project options metadata, you need thebigquery.config.getIdentity and Access Management (IAM) permission.
The following predefined IAM role includes thepermissions that you need in order to get effective project options metadata:
roles/bigquery.jobUser
For more information about granular BigQuery permissions, seeroles and permissions.
Schema
When you query theINFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS view, the query results contain one row for each configuration in a project.
TheINFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS view has the following schema:
| Column name | Data type | Value |
|---|---|---|
project_id | STRING | The ID of the project. |
project_number | INTEGER | Number of the project. |
option_name | STRING | Option ID for the specified configuration setting. |
option_description | STRING | The option description. |
option_type | STRING | The data type of theOPTION_VALUE. |
option_set_level | STRING | The level in the hierarchy at which the setting is defined, with possible values ofDEFAULT,ORGANIZATION, orPROJECTS. |
option_set_on_id | STRING | Set value based on value ofoption_set_level:
|
option_value | STRING | The current value of the option. |
Options table
option_name | option_type | option_value |
|---|---|---|
default_time_zone | STRING | The effective default time zone for this project. |
default_kms_key_name | STRING | The effective default key name for this project. |
default_query_job_timeout_ms | INT64 | The effective default query timeout in milliseconds for this project. |
default_interactive_query_queue_timeout_ms | STRING | The effective default timeout in milliseconds for queued interactive queries for this project. |
default_batch_query_queue_timeout_ms | STRING | The effective default timeout in milliseconds for queued batch queries for this project. |
enable_reservation_based_fairness | BOOL | Use reservation-based fairness as opposed to project-based fairness. |
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.
| View name | Resource scope | Region scope |
|---|---|---|
`region-REGION`.INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS | Configuration options within the specified project. | REGION |
Replace the following:
REGION: anydataset region name. For example,region-us.
Examples
The following example retrieves theOPTION_NAME,OPTION_TYPE,OPTION_VALUE,OPTION_SET_LEVEL, andOPTION_SET_ON_ID columns from theINFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS view.
SELECToption_name,option_type,option_value,option_set_level,option_set_on_idFROM`region-REGION`.INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS;
INFORMATION_SCHEMA view names are case-sensitive.The result is similar to the following:
+--------------------------------------------+-------------+---------------------+------------------+--------------------+ | option_name | option_type | option_value | option_set_level | option_set_on_id | +--------------------------------------------+-------------+---------------------+------------------+--------------------+ | default_time_zone | STRING | America/Los_Angeles | organizations | my_organization_id | +--------------------------------------------+-------------+---------------------+------------------+--------------------+ | default_kms_key_name | STRING | test/testkey1 | projects | my_project_id | +--------------------------------------------+-------------+---------------------+------------------+--------------------+ | default_query_job_timeout_ms | INT64 | 18000000 | projects | my_project_id | +--------------------------------------------+-------------+---------------------+------------------+--------------------+ | default_interactive_query_queue_timeout_ms | INT64 | 600000 | organization | my_organization_id | +--------------------------------------------+-------------+---------------------+------------------+--------------------+ | default_batch_query_queue_timeout_ms | INT64 | 1200000 | projects | my_project_id | +--------------------------------------------+-------------+---------------------+------------------+--------------------+
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-12-15 UTC.