Troubleshooting paginated stream with incomplete data in Snowflake destination

Hmm, I don’t know enough to give you a confident answer yet. However, based on the information provided, it seems like there might be an issue with the sync process. There are several reasons why not all records are being synced. It could be due to an error in the source connector, an issue with the destination connector, or a problem with the sync mode configuration. In some of the extracts, users have reported similar issues where not all records are being synced. For example, in this forum post, a user reported that only part of the data was being synced from Postgres to Snowflake. The sync would abort partway through with an error message, but then claim success. The user tried different modes of synchronization but got the same result each time. In this Github issue, a user reported that in a full replace sync, final tables were replaced with empty temp tables on source error. The source would stop fetching new data after an error, and the destination would assume that all data that should be loaded had been fetched. It would then replace all destination tables with their temp counterparts, whether empty or not. Without more specific information about your situation, it’s hard to provide a definitive answer. I would recommend checking the job logs for any warnings or errors that might indicate what’s going wrong. You might also want to try different sync modes to see if that makes a difference. For more information, you can refer to the Airbyte documentation or ask for help in the Airbyte forum or Slack channel.