Chris (deprecated profile)
Arrays of Arrays of XXX
, you need to build Arrays of Record of Arrays of XXX
instead
I know Stitch is choosing to add a .value
every-time you have a record/array field when creating the columns in BQ:
https://www.stitchdata.com/docs/replication/loading/google-bigquery-storing-nested-data-structures#storing-nested-records
Actually, whenever there is an Array of
they automatically build a Record of Array of
using that extra .value
field.
So you might end up with things like *`friend_ids.value.value` *in the case of arrays of arrays…
I’m wondering how does other do it? or how should Airbyte do this?Prashanth Patali
06/16/2021, 5:55 PM