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

 

Questions


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?

 

 

————————————————-

Answer

google-bigquery

Facebook Comments

Post a comment