Summary
The user is looking for a way to unnest nested fields (properties and associations) in the Hubspot connector for BigQuery destination as they are written as JSON. They are using the low code UI and cannot find options for unnesting in the interface.
Question
hey, I am using the low code UI to create a connector to Hubspot (there is a stream thatI need which is not supported in the default connector). In the data, there are 2 nested fields (properties and associations) that are written as json to my BQ destination. Is there any easy way to unnest them in the source? I can’t find any options for it in the interface
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.