Converting jsonb field to RECORD type in BigQuery

I’m using stitch to integrate data from a postgres server into google bigquery.
I have a field with type JSONB that stores data similiar to this:
user {"firstName": "xxx", "lastName": "xxx"}
According to stitch docs, when this field is copied to BigQuery, it’s suppose to have type “RECORD”, then I can easily query it.
Instead, when the data is imported to BigQuery, the field has a type “STRING” so we can’t easily query.
Any solution for it?

Shulamit, if you haven’t already, I’d encourage you to ask Stitch support your question —

1 Like