@kapa.ai The is some backed up data I’d like to manually copy to one of my destinations tables Is there anything I can do, prior to insert in the table? do I have to also copy it to the airbyte raw? etc…

When using Airbyte for data synchronization, the process typically involves copying data from the source to a raw table in the destination, and then normalizing this raw data into the final destination table. This process is handled by Airbyte and dbt-generated SQL commands. If you have backed up data that you want to manually insert into one of your destination tables, you would typically insert this data directly into your source table. Airbyte would then handle the process of copying this new record to the raw table in the destination, and normalizing it into the final destination table. For example, in the case of incremental append synchronization, when you insert a new record into the source table, this new record will be appended to the raw table in the destination and will then be normalized and appended to the final data table. However, it's important to note that the raw table in the destination also contains additional fields added by Airbyte, such as _airbyte_emitted_at which tells you what time Airbyte sent the record to the destination, and _airbyte_ab_id which is a UUID value added by the destination connector to each record before it is sent to the destination. Therefore, if you're considering manually inserting data into the destination tables, you would need to ensure that these additional fields are also correctly populated. It's also worth noting that you need to prepare the database and tables that will be used to store synced data from Airbyte, and ensure the order and matching of the column names in the table as much as possible. Sources: - [Incremental append synchronization](https://airbyte.com/tutorials/incremental-data-synchronization#step-6) - [Target Database and tables](https://docs.airbyte.com/integrations/destinations/selectdb#target-database-and-tables)