Vinicius Nunes
04/15/2026, 3:15 PMkapa.ai
04/15/2026, 3:15 PMdestination-bigquery connector runs queries like MAX(_airbyte_extracted_at) on raw tables, which can scan significant data volumes. A community-suggested workaround is to create a Materialized View in BigQuery to reduce scan costs: [BigQuery cost issue]
CREATE MATERIALIZED VIEW AS `airbyte_internal.xxxxx_db_eu_raw__stream_xxxxx_airbyte_extracted_at`
SELECT MAX(_airbyte_extracted_at) AS _airbyte_extracted_at FROM `airbyte_internal.xxxxx_db_eu_raw__stream_xxxxx`
This reportedly reduced query costs from scanning GBs to just 8 bytes in testing. Monitoring via the Connection Timeline You can also review the Connection Timeline in the Airbyte UI to track data volumes per sync (GB/KB/MB moved, records extracted and loaded), which can help you manually estimate costs over time. [Connection timeline]
The knowledge sources do not mention any automated cost calculator or API endpoint for cost estimation beyond these approaches. š 0 button š 0 button ā¹ļø Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help., with interactive elements