Repeatedly synchronizing entire Invoices table

[brylie]

We are using Stitch-managed version of Singer with the tap-chargebee enabled and noticed that we were hitting our row limit.

The Chargebee tap is replicating all of the rows in the Invoices table repeatedly, instead of the new rows only. What can we do to prevent the tap-chargebee from replicating the entire table, and all related tables, each night?

[brylie]

Specifically, does this tap support INCREMENTAL_UPDATE?

[cb-nandita]

@brylie,
Hope you are doing well.
Could you please check and confirm if there are any errors in the Stitch logs? Are all the syncs successful ?

[brylie]

I will re-enable the Invoices table sync.

[brylie]

I re-enabled the invoices table sync in Stitchdata.com and the row count skyrocketed:

There do not appear to be any errors in the replication log. I will check again tomorrow to see if we have the same row replication issue.

[brylie]

The weird thing above is it says there were 7.6 M rows loaded into the data warehouse that day, while the bar chart shows 37.5 M total rows loaded. I don't understand the discrepancy.

[brylie]

Here is the usage increase after re-enabling the Invoices table sync:

[brylie]

The spike in rows loaded seems to have passed, and things are back to the previous, upwards cumulative trend.