Is there a way to select nested records into a table?



I have a table, T, in Bigquery which contains simple fields and one nested field.

I would like to effectively “select * from T where …” and store the result in a new table U.

I want U to have the same schema as T (including the nested field).

Is there a way to do this within Bigquery or is the solution to export/transform/import?






Facebook Comments

Post a comment