ORGANIZATION_OPTIONS_CHANGES view

You can query theINFORMATION_SCHEMA.ORGANIZATION_OPTIONS_CHANGES view to retrievereal-time metadata about BigQuery configuration changes in anorganization.This view reflects organization-level and project-level configuration changesmade after January 31, 2024.

Required permissions

To get the permission that you need to get the configuration changes, ask your administrator to grant you theBigQuery Admin (roles/bigquery.admin) IAM role on your organization. For more information about granting roles, seeManage access to projects, folders, and organizations.

This predefined role contains the bigquery.config.update permission, which is required to get the configuration changes.

You might also be able to get this permission withcustom roles or otherpredefined roles.

Schema

When you query theINFORMATION_SCHEMA.ORGANIZATION_OPTIONS_CHANGES view, the queryresults contain one row for each configuration change in an organization.

TheINFORMATION_SCHEMA.ORGANIZATION_OPTIONS_CHANGES view has the following schema:

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.

Replace the following:

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

Examples

The following example retrieves all changes of thedefault_query_job_timeout_ms option option:

SELECT*FROM`region-REGION`.INFORMATION_SCHEMA.ORGANIZATION_OPTIONS_CHANGESWHEREupdated_options.default_query_job_timeout_msisnotnull;

+----------------+------------+-------------------------+-----------------+------------------------------------------------------------------------------------------------------------------+| 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_query_job_timeout_ms":{"new":1860369,"old":1860008}}                                                   |+----------------+------------+-------------------------+-----------------+------------------------------------------------------------------------------------------------------------------+