Console

Service Health

This page provides status information on the services that are part of Google Cloud. Check back here to view the current status of the services listed below. If you are experiencing an issue not listed here, please contact Support. Learn more about what's posted on the dashboard in this FAQ. For additional information on these services, please visit https://cloud.google.com/.

Incident affecting Google BigQuery

Multiregion: Query errors and failures for BigQuery customers

Incident began at 2023-03-31 10:46 and ended at 2023-03-31 12:28 (all times are US/Pacific).

Previously affected location(s)

Taiwan (asia-east1)Hong Kong (asia-east2)Tokyo (asia-northeast1)Osaka (asia-northeast2)Seoul (asia-northeast3)Mumbai (asia-south1)Delhi (asia-south2)Singapore (asia-southeast1)Jakarta (asia-southeast2)Sydney (australia-southeast1)Melbourne (australia-southeast2)Warsaw (europe-central2)Finland (europe-north1)Madrid (europe-southwest1)Belgium (europe-west1)London (europe-west2)Frankfurt (europe-west3)Netherlands (europe-west4)Zurich (europe-west6)Milan (europe-west8)Montréal (northamerica-northeast1)Toronto (northamerica-northeast2)São Paulo (southamerica-east1)Santiago (southamerica-west1)Iowa (us-central1)South Carolina (us-east1)Northern Virginia (us-east4)Oregon (us-west1)Los Angeles (us-west2)Salt Lake City (us-west3)Las Vegas (us-west4)

Date Time Description
31 Mar 2023 12:28 PDT

An unsupported query pattern related to array access such as array[position] caused temporary failure of some queries on Monday, 2023-03-27 13:12 US/Pacific to Monday, 2023-03-27 13:30 due to a change in BigQuery. We have successfully rolled back the change that led to this issue.

There is no further impact due to this issue for our customers.

We thank you for your patience while we worked on resolving the issue.
31 Mar 2023 11:36 PDT

Summary: Multiregion: Query errors and failures for BigQuery customers

Description: Our engineering team continues to investigate the issue and is verifying the details of customer impact.

We will provide more information by Friday, 2023-03-31 13:00 US/Pacific.

Diagnosis: Customers impacted by this issue will receive query errors Array element access with array[position] is not supported. Use array [OFFSET(zero_based_offset)] or array[ORDINAL(one_based_ordinal)]

Workaround: To mitigate the issue, customers can change a[n] to a[OFFSET(n)] for arrays. For structs the workaround is to refer to members by name, e.g. instead of s[OFFSET(3)] write s.field3.
31 Mar 2023 11:15 PDT

Summary: Multiregion: Query errors and failures for BigQuery customers

Description: We are experiencing an issue with Google BigQuery beginning at Monday, 2023-03-13 00:00 US/Pacific.

Our engineering team continues to investigate the issue.

We will provide an update by Friday, 2023-03-31 11:48 US/Pacific with current details.

We apologize to all who are affected by the disruption.

Diagnosis: Customers impacted by this issue will receive query errors Array element access with array[position] is not supported. Use array [OFFSET(zero_based_offset)] or array[ORDINAL(one_based_ordinal)]

Workaround: None at this time.