I am having the exact question as this person in the link below:

I have a declared variable in bigquery with words that I want to identify in a table

I know there is the SELECT AS STRUCT construction in BigQuery, but wouldn’t the following do the exact same thing? Or does the AS STRUCT construction give any additional benefits?

I have a table with extracted currency exchange rates refreshing every day. It’s schema is Date_field / JSON_field
I need to “unnest” the json to be able to use it further with BigQuery sql as far as I believe.

I have an unpartitioned BigQuery table with some 425k rows scattered over 1-2 years.

I’m tryin to uplaod csv file to bigquery using spring – boot java
I;m getting 400 invaid data

trying to backup GA4 Data in Big Query, data stream events are pulling in however events are expiring after 60 days despite upgrading from Sanbox and settting the renetention period to “Never”

Is it possible to submit a feature request for the big query UI somewhere? I found this: Where to submit new feature request for BigQuery? but I don’t see anything about the UI here?

I need to count how much sessions where received with such parameter.
But it gives too much of results after execution, I think it’s because of UNNEST function. How can I count correctly sessions?

o am trying tô update a field that is structure type but o have This error:
Update set does not support array modification with []