Summary
User inquires about the possibility of implementing transformation options in the Facebook connector to split array columns into individual rows before loading data into 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.