Missing Addons imported to redshift

[harz87]

I have the Chargebee Integration running through Stitch. I just noticed that the addons imported to redshift does not include the full list which is available in Chargebee. I do have 10 addons in warehouse and 30 addons in Chargebee. What is the potential root cause for this issue.

[theresemoreau]

Hello @harz87 , I’m currently having the same issue loading subscriptions into BQ. I tried several times to do a full reload, however, each time I get a different number of rows loaded into BQ. First time I got 165.777 rows, an hour later I got 82.981, but the real number should be closer to 1 million.
Logs indicate no errors. I can't find any reason the difference.

Have you come across the same issue?

EDIT: I have now also tried doing a full reload of our addons table, which contains 93 rows. Only 71 are loaded. Again, no error messages in the log file and I can't see any pattern as to missing records.

[harz87]

Hey @theresemoreau for subscriptions I do not face this issue. They get updated or added as new subscriptions appear. For the addons issue, I haven't found a solution or pattern either yet.