I have a biquery schema like this:
Column | Type | Mode |
---|---|---|
id | NUMERIC | NULLABLE |
pkey | STRING | NULLABLE |
description | STRING | NULLABLE |
created | TIMESTAMP | NULLABLE |
updated | TIMESTAMP | NULLABLE |
labels | STRING | REPEATED |
components | STRING | REPEATED |
parent | FLOAT | NULLABLE |
score | NUMERIC | REPEATED |
country | STRING | NULLABLE |
channel | STRING | REPEATED |
platform | STRING | REPEATED |
That table have 3000 records
I need to create a new table with all unnested fields without creating duplicates records or losing records,
Important: the real table have +100 fields, some of REPEATED field contains null records
I’m trying but I can’t do it, thanks in advance…