PROJECT_OPTIONS_CHANGES view

You can query theINFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES view to retrievereal-time metadata about BigQuery configuration changes of a project.This view reflects project-level configuration changesmade after January 31, 2024.

Required permissions

To get the configuration, you need thebigquery.config.updateIdentity and Access Management (IAM) permission at the project level. The predefinedIAM roleroles/bigquery.admin includes the permissions that youneed to create a configuration.

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

Schema

When you query theINFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES view, the queryresults contain one row for each configuration change in a project.

TheINFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES view has the following schema:

Column name	Data type	Value
`update_time`	`TIMESTAMP`	The time the configuration change occurred.
`username`	`STRING`	For first-party users, it's their user email. For third-party users, it's the name that users set in the third-party identity provider.
`updated_options`	`JSON`	A JSON object of the configuration options users updated in the change, containing the previous and the new values of updated fields.
`project_id`	`STRING`	The project ID. This field is empty for organization-level configuration changes.
`project_number`	`INTEGER`	The project number. This field is empty for the organization-level configuration changes.

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 sessions that are running and the history of sessionscompleted 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.PROJECT_OPTIONS_CHANGES	Configuration changes within the specified project.	`REGION`

Replace the following:

REGION: anydataset region name. For example,US, orus-west2.

Note: To learn how to extract a JSON scalar value from theupdated_optionscolumn and convert it to a SQL STRING value such asJSON_VALUE(), see JSON functions.

Examples

The following example retrieves all columns from theINFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES view.

SELECT*FROM`region-REGION`.INFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES;

Note:INFORMATION_SCHEMA view names are case-sensitive.

The result is similar to the following:

+----------------+------------+-------------------------+-----------------+------------------------------------------------------------------------------------------------------------------+| project_number | project_id | update_time             | username        | updated_options                                                                                                  ||----------------|------------|-------------------------|-----------------|------------------------------------------------------------------------------------------------------------------|| 4471534625     | myproject1 | 2023-08-22 06:57:49 UTC | user1@gmail.com | {"default_query_job_timeout_ms":{"new":0,"old":1860369},"default_time_zone":{"new":"America/New_York","old":""}} ||----------------|------------|-------------------------|-----------------|------------------------------------------------------------------------------------------------------------------|| 5027725474     | myproject2 | 2022-08-01 00:00:00 UTC | user2@gmail.com | {"default_interactive_query_queue_timeout_ms":{"new":1860369,"old":1860008}}                                     |+----------------+------------+-------------------------+-----------------+------------------------------------------------------------------------------------------------------------------+

Except as otherwise noted, the content of this page is licensed under the Creative 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.