Hi team. I am currently using Airbyte with the source File module to populate a Postgres destination. The sync mode chosen is 'Full refresh | Overwrite'. I note after each file sync that the views I have created on the db tables are removed. It makes me wonder if this sync mode is somehow proceeding to a drop table with cascades: if so, how can I proceed to get the job done ('cancel & replace') without droping the tables and my views? or if this feature should have to be implemented. Thx 👍

I note after each file sync that the views I have created on the db tables are removed.

Today this is a limitation and Airbyte will drop the table created. You can try to use full refresh append which will not drop the table but will apend data, so you can have maybe a store procedure to clean it or views to query the data.