Hi everyone! We have set up a connection between

Salesforce

and

BigQuery

. We have run it multiples times, with same start date and

Full refresh | Overwrite

as sync mode and we have noticed that the number of

emitted records

has been decreasing. Is this an expected behaviour? If so, could you please explain why this happens? Thanks!

Some API Sources have a limitation of how far you can ingest data others for some streams allow reading only with samples, not sure if it is the case of Salesforce. Do you have more information if this is happening to all streams of a particular one? The data missing is random or is the old data records?

We are using a recent start date (2022-11-20), so I guess the records should be available.

I recommend to you create an issue in Github explaining the problem, if the records are the old one or random ones. Which streams are you using too.