Summary
The user is looking for transformation options in the Facebook connector to automatically split columns into rows for each entry in the array before storing data in BigQuery.
Question
Hi everyone! I’m new to airbyte. I noticed the facebook connector doesn’t have any transformation options. I’d love to automatically split the actions and action_value columns into a row for each entry in the array. I understand I could do this after the table has been loaded, but wanted to get input on whether it’s possible to do this before the data is originally stored in bigquery.
[{"1d_click":38,"1d_view":270,"28d_click":38,"28d_view":270,"7d_click":38,"7d_view":270,"action_type":"page_engagement","value":273},{"1d_click":38,"1d_view":270,"28d_click":38,"28d_view":270,"7d_click":38,"7d_view":270,"action_type":"post_engagement","value":273},{"1d_click":33,"28d_click":33,"7d_click":33,"action_type":"link_click","value":33},{"1d_click":2,"1d_view":270,"28d_click":2,"28d_view":270,"7d_click":2,"7d_view":270,"action_type":"video_view","value":272}]
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.