Source Table SCHMEA Target Table SCHEMA I’m trying to copy Source table records into targed table and am running into the following error Query column 2 has type ARRAY<STRUCT<Name STRING, Value STRING>> which cannot be inserted into column request, which has type STRUCT<movie ARRAY<STRUCT<name STRING, Budget STRING INSERT INTO `<GCP_PROJECT_NAME>.Test_Tables.Nested_Person_Table2` (Actor, director) SELECT protagonist, STRUCT([STRUCT(mo.Name as Name, mo.Budget as Budget)] as movie, “” as language, “” as English, “” as other, STRUCT(“”,””) as source) as director FROM `<GCP_PROJECT_NAME>.Dataset.Table`, UNNEST(movie) as mo Expected output: All the records present in the source…
Read More