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…