Netsuite Warning: Not Recommended: This Table Is Not Incremental and Syncs Slowly...link
Updated 12 days ago
Introductionlink
This article describes how to control the sync timing of large tables that require a full re-sync once per week. The following pop-up is seen when hovering over the Table Resync icon:
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.
content_copyEnvironmentlink
Connector: NetSuite SuiteAnalytics
Answerlink
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).
Causelink
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.