Given a table like the following

I’m trying to use the Simba ODBC Windows driver to work with BigData. It connects and tests out fine in the ODBC Data Source Administrator. When connecting from Excel:

We have table in BQ where two of the columns are like this:

I’m doing an export of several BigQuery tables and I’m looking to create a loop to do so. See below.

I know how to export a table from BigQuery to Google Cloud Storage (via console, SQL or bq). Of course this is time consuming if I have lots of tables to export.

I need to update data in BigQuery. Data comes from CRM by API . I didn’t set up this connection, so I don’t understand, what’s wrong.

I need to update data in BigQuery. Data comes from CRM by API . I didn’t set up this connection, so I don’t understand, what’s wrong.

Small question on bigquery, for deployment infra automation, it seem terraform with google provide doens’t support yet the adding replica in case au multi region.
Google has announce few month a go, in backlog development.

I know how to export a table from BigQuery to Google Cloud Storage (via console, SQL or bq). Of course this is time consuming if I have lots of tables to export.

Is it possible to use UNNEST in a SELECT statement for selecting column names?