<@U04SE163WC8> I recently migrated to destination...
# replication-ask-ai
p
@kapa.ai I recently migrated to destination v2 which is not generating _scd table anymore, my questions is: how can I have a table with the history of changes, but also having record when the data has change and not just do an append for every sync. Also, is possible to have a table with the historical data and one with the current state as we had before with _scd and non _scd tables?
k
New message text here
p
@kapa.ai I am using version 2.1.5 of bigquery destination, which does not generate _scd tables
k
A message from kapa.ai
I see, it seems like you're using a version of the BigQuery destination that doesn't generate _scd tables. Unfortunately, based on the information provided in the extracts, there's no direct mention of how to handle this specific situation. However, Airbyte does support Incremental Sync - Deduped History mode which generates a history table (also known as the scd table) and a deduped table. This mode is designed to keep track of historical changes and maintain a table with the current state of data [source](https://airbyte.com/tutorials/incremental-data-synchronization). If this mode is not working as expected with your current version of BigQuery destination, it might be a good idea to check the Airbyte documentation or reach out to the Airbyte community for more specific guidance. I recommend checking the [Airbyte documentation](https://docs.airbyte.com) for updates or changes related to your specific version of BigQuery destination. If you can't find the information you need, consider asking your question in the [Airbyte community forum](https://discuss.airbyte.io) or [Airbyte's Slack workspace](https://airbytehq.slack.com) for more specific help.