Hey everyone. I'm currently trying to use Airbyte ...
# troubleshooting
j
Hey everyone. I'm currently trying to use Airbyte to grab google analytics events data from BigQuery and dump it into Databricks. The reason I'm doing this is because this gives more more granular data than the default GA connector, which just uses the API to pull different reports. Right now, I'm getting errors in the Airbyte connector, which I learned is because my table in BigQuery is using nested arrays in the table (a
record
in BigQuery language). I tested this theory with a table that didn't have nested arrays and it worked fine. So, I know the problem, but turning the raw GA data into a flat table is no small feat. So, here are my questions: 1. Does Airbyte support ingesting data from BigQuery that is semi-structured? 2. If not, anybody know how to help me flatten out this table in BigQuery?