hello team, I'm getting used to connectors from googlesheet -> postgres and working just fine for most cases. I'm generally very happy with the syncs but i wonder why the 'full refresh' is implemented by dropping and recreating the tables instead of truncating. I am trying to maintain views on top of the airbyte tables (not using dbt because the view don't change) but they keep getting dropped. Can someone help me understand if i'm configuring this wrong or point me to some documentation? thanks!

It’s easy in case new columns maybe in the future with schema evolution will be possible to truncate. But today is a limitation Airbyte has

noted, thanks

Maybe you could get around this by using a staging are as the target for the full refresh then a dbt merge transform to update the final table.

Thanks, @Nigel Ainscoe. I appreciate the suggestion. Unfortunately, we only use DBT cloud and I am yet to figure out how to connect it properly to airbyte. Do you have any suggestions/docs there?

No, sorry we are using dbt core.