Hi. How can I use the "BigQuery (denormalized type...
# ask-ai
s
Hi. How can I use the "BigQuery (denormalized typed struct)" destination, are there any docs(except the general docs on BigQuery dest.)? My issue is it doesn't make a correct schema(for a field which is an object) for BigQuery I guess, from logs:
Copy code
BigQueryError{reason=invalid, location=null, message=Error while reading data, error message: JSON parsing error in row starting at position 0: JSON object specified for non-record field: meta}
I thought this destination transforms all the fields to their corresponding JSON structs or primitives. My source is MongoDB.
It may be related to this MongoDB source issue("Source MongoDB: nested fields are converted to string")