Warning: Not Recommended: This Table Is Not Incremental and Syncs Slowly
Issue
While hovering over the Table Resync icon, the following warning appears:
Not recommended: This table is not incremental and syncs slowly. It will be updated once per weekend. Selecting it can cause an increase in MAR.
Environment
Connector: NetSuite SuiteAnalytics
Resolution
Create a new Netsuite connector that connects to the same Netsuite account.
Within the new connector, deselect all tables except the table you'd like to manually schedule.
Within the original connector, deselect the table which you will manually schedule.
NOTE: Deselecting the table in the original connector is necessary to limit your Monthly Active Rows (MAR).
Cause
Tables without one of the timestamp columns must be re-imported in full to update. To maintain the speed of overall updates, the frequency with which we update most of these re-import tables is based on how fast we can ingest them from NetSuite. This speed is entirely dependent on NetSuite performance.
| Table re-sync duration | Table re-sync frequency |
|---|---|
| 20 seconds or less | Every sync |
| Between 20 seconds and 60 minutes | Twice a day |
| More than 60 minutes | Once a week |
NOTE: See the Updating Data section of our NetSuite SuiteAnalytics or go the Schema tab on the connector details page to learn about the re-import frequency of each re-import table. We mark the tables that take longer than 20 seconds to import as not recommended in the dashboard and include a message on how frequently Fivetran syncs them. They are excluded from the sync by default because they degrade performance. However, you can choose to include them.