When you choose the Incremental Append sync mode in Airbyte, the current data is determined by the cursor field. Some sources are able to determine the cursor that they use without any user input. For example, in the exchange rates source, the source knows that the date field should be used to determine the last record that was synced. In these cases, you simply select the incremental option in the UI ([source](https://docs.airbyte.com/using-airbyte/core-concepts/sync-modes/incremental-append#source-defined-cursor)). However, with Incremental Append, a record which was updated in the source will be appended to the destination rather than updated in-place. This means that if data in the source uses a primary key (e.g:

user_id

in the

users

table), then the destination will end up having multiple records with the same primary key value. If you only care about having the latest snapshot of your data, you may want to look at other sync modes that will keep smaller copies of the replicated data or you can periodically run cleanup jobs which retain only the latest instance of each record ([source](https://docs.airbyte.com/using-airbyte/core-concepts/sync-modes/incremental-append#getting-the-latest-snapshot-of-data)). To view the content of the incremental append synchronization into the raw table, you can execute the following SQL command:

sql SELECT * FROM _airbyte_raw_table_one;

This should respond with a table that contains the data from the incremental append synchronization ([source](https://airbyte.com/tutorials/incremental-data-synchronization#step-6)).