I don’t understand how I can filter out all the

_airbyte_tmp_

and

_airbyte_raw_

tables from my migration. Is there a way to have those go somewhere else so my schema isn’t filled with all these tables cluttering up the tables we actually use?

The

_tmp

tables are deleted if the sync is finished successfully but they aren’t deleted in the case for a failed connection. There is an issue to correct this problem. The raw tables if you are using full overwrite or incremental + dedup you can delete them. But for that you need to create a sript to delete them yourself.