Is there like a quick pros and cons for the two bigquery connector modes? • bigquery with basic normalization • bigquery(denormalized) Not sure which one to use. there is plan to run separate dbt transformations on the data after airbyte extracts them to bigquery. any insights is appreciated!

@Chris Duong [Airbyte] 😅 your question again

sry if this was frequently asked. I searched and read thru multiple pages without good results before raising the question 😛 do point me the right direction if there is similar discussion somewhere 🙏

We just mentioned and discussed it orally! Just funny timing! You can probably use both and do your own transformations afterward regardless of your choice You might encounter some exceptions depending on the complexity of your data, and switch out to the other option if that works better If you go with bigquery denormalized you might limited and not being able to choose some sync modes (dedup) but you can still totally handle it in your own transformation pipelines