Is this your first time deploying Airbyte: No OS Version / Instance: Debian GNU/Linux, 10 (buster), GCP ,n2-standard-2 Memory / Disk: 2 vCPU, 8Gb RAM / 50GB Balanced persistent disk Deployment: Docker Airbyte Version: 0.35.59-alpha Source name/version: Hubspot 0.1.50 Destination name/version: BigQuery 1.0.0 Description: When starting the first incremental sync for the company stream, it stops at 1.7M/6.6M records read. For some reason, the state is modified during the first full sync. (“Advancing bookmark for companies stream from None to 2022-03-23T205211.671000+00:00”). After that, the incremental sync seems okay but I have missing company due to a incomplete first full sync. Thanks for your help 🙏

@Elliot Trabac the sync finished successfully right? Do you have the correct diff you’re seeing from Airbyte counts and the Hubspot?

Yes the sync was successful No I only have 1.8M records instead of 6.6M in the UI

In the Hubspot side?

Yes! A company_id not sorted caused a huge gap in the pagination