Airbyte -> BigQuery _table bug
🪲Bug Report
I am trying to export Convex through Airbyte to a Bigquery dataset. I'm quite familiar with Airbyte but this is the first time using it with Convex. Setup seemed pretty straightforward and I set the tables I wanted to export.
Attached is one of my tables that streams into bigQuery. As you can see it has a few table created by Convex (or the owner of the Airbyte connector). In the output, it seems to mix multiple tables into a single dataset. For example, it should just be exporting
When I run
I might be missing something with the setup, but I can't find anything online. Thanks in advance!
Attached is one of my tables that streams into bigQuery. As you can see it has a few table created by Convex (or the owner of the Airbyte connector). In the output, it seems to mix multiple tables into a single dataset. For example, it should just be exporting
affiliatesaffiliates data into raw_affiliatesraw_affiliates, but it seems to export multiple tables from convex into raw_affiliatesraw_affiliates, but fitting it into the affiliates schema. It's strange, and it seems like some data is missing from affiliatesaffiliates too.When I run
SELECT DISTINCT _tableSELECT DISTINCT _table on raw_affiliatesraw_affiliates it shows a list of all the tables in my convex application. Note that the second screenshot just shows a portion of the output, but it does show all tables. If it wasn't missing data I could just filter by _table, but it's still missing affiliatesaffiliates rows. I might be missing something with the setup, but I can't find anything online. Thanks in advance!
