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.