Summary
User inquires about the expected behavior of the BigQuery destination when loading data from Shopify, specifically regarding the format of nested fields and whether the output as JSON is correct for version compatibility.
Question
Hello everyone, I have a question regarding destination - Bigquery
I have source - shopify and I am loading orders and customers tables.
Earlier, I used to load the same tables using Bigquery denoramalized and nested fields used to load as RECORD .
Now with Bigquery I get the same fields as JSON. I want to know if this is what I should expect from Bigquery destination V2 ?
Or am I doing something wrong? (I am on v0.50.30 and the bigquery destination is on v2.3.28 )
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.