@kapa.ai Hey there, I've created incremental sync from MongoDB to Bigquery and suddenly my bigquery daily cost have gone up from 2€ per day to 6€ per day, i'm doing incremental syncs from a collection of 7M rows, how can i reduce the cost?

Based on the knowledge sources provided, there are a few potential ways to reduce the cost of BigQuery when using Airbyte for incremental syncs: 1. Optimize SQL Queries: One user on the Airbyte forum noticed that the auto-generated BigQuery SQL script was not optimized, which led to higher costs. You might want to check the SQL history log on BigQuery to see if there's any room for optimization. [Source](https://discuss.airbyte.io/t/1515) 2. Adjust Sync Frequency: Another user noticed high charges from BigQuery due to frequent syncs (every 5 minutes). Reducing the frequency of syncs could potentially lower costs. However, this might not be an option if you need near real-time data. [Source](https://discuss.airbyte.io/t/1451) 3. Review Deduplication and History Settings: If you're using deduplication and history settings in BigQuery, this could be increasing the amount of data processed and therefore the cost. One user found that the DBT models used to normalize, historize, and merge the data in the destination BigQuery table processed 6 times more data than the destination BigQuery table. [Source](https://discuss.airbyte.io/t/2445) Unfortunately, without more specific information about your setup and usage, it's hard to provide more targeted advice. You might want to consider reaching out to the Airbyte community or support for more assistance.