Why Is My Sync Slow or Delayed?

Question

Why is my sync slow or delayed?

Environment

Connector: NetSuite SuiteAnalytics

Answer

To find out why your NetSuite SuiteAnalytics connector's sync is slow or delayed, see the common causes below.

Re-import tables

Once a week, we re-import large tables that take more than 60 minutes to ingest, during which you may experience a longer sync time than usual. For the list of applicable tables, see our NetSuite SuiteAnalytics re-import documentation.

Significant data changes

To detect deleted records, we divide tables into contiguous chunks and re-import the chunks for which we detect change. If you have modified or deleted many records, we may need to re-import more tables than usual, impacting your sync time. For the list of applicable tables, see our NetSuite SuiteAnalytics data deletion documentation.

In the LOG table of the Fivetran Platform Connector, you can check the number of records_modified events reflected for each applicable table to determine whether the above strategies impacted your sync.