As a CDO in a fintech company in Brazil, I bought one-month skyvia service to better test it once I am seriously considering use it to feed our data lake as most of our data are from CRM Dynamics 356, Google Analytics, Pipedrive, SAP, and excel files hosted in S3 buckets.
During the homologation process in a scheduled replication package from Dynamics to a PostgreSQL database, after three days of successful replication, I disabled it. One day later I enabled it again and surprisingly all rows were updated not only the difference as usual but all of them and thus the row limit was surpassed by far. Is it right? How can I avoid it? I expected only the changed data to be updated. It seems that we can never stop or disable a package otherwise we are going to be overwhelmingly billed.
Looking forward to hearing from you..