Hi all and happy new year. I'm looking for a way to split the _airbyte tables into their own dataset separately from the basic normalization tables as they enter bigquery, is there a way to do this currently? The use case would be to make navigation simpler

Hi @Donovan Maree, do you mean keeping raw tables in a different dataset than the table outputted by the basic normalization?

yes thats correct

It's something you can achieve by running a custom transformation with DBT. You can retrieve the generated models for normalization and adapt them to change the destination dataset. We have a guide here about custom transformations.

you can configure airbyte to replicate into some “staging” dataset as a destination Then, you should disable basic normalization option. In one of your previous sync, you can download the generated normalization/dbt project and add to github repository while changing the target destination of normalized tables as Augustin linked so you can have your custom results