Multiregion: Query errors and failures for BigQuery customers

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.

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.

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.