Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hi there,
When I connect Stripe to BigQuerry, it's really strange, I only have 20 tables in Stripe and in GCP,  Airbyte creates more than 100 tables ... Hundreds of empty tables... Any idea why ? Someone had the same issue ?
Thanks for your help

I have the same, I guess it's because it's an API source and the API returns nested data so Airbyte unfolds it in several tables

Thx for your answer <@U02MB53AA67> ! Any idea how to fix this ?

Why is it a problem ? I guess you could edit the connector code to retain the nested data in a json in the parent table, but it's a lot of work, rather than just querying the tables..

Hi <@U0338KZGEG4>, as Anatole suggested, this is due to the normalization Airbyte runs. You can disable normalization, or implement a custom transformation with DBT if you want to change this behavior. You'll find a guide <https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-airbyte|here>.

Thank you very much <@U02UC3T12PJ> !! I definitely have to work with DBT !