NetSuite Connector Improvement with Table Re-Naming
AnsweredWhich connector?:
NetSuite
Additional details:
When a source table is renamed or recased (e.g., NetSuite's "accountingperiod" → "AccountingPeriod"), Fivetran treats it as two separate events: the old table marked deleted, and the new table discovered. For customers with Schema Change Handling set to "Block all new data" — the standard setting for sources with thousands of tables where only a subset is synced — the "new" table is added in a disabled state.
The result: a cosmetic, no-op source change silently halts the sync indefinitely, with no notification to the customer. In our case this went undetected for several weeks on a NetSuite
table that feeds financial reporting.
Detect rename and recase as a distinct event type — the table is logically the same — and preserve sync continuity automatically, rather than handling it as drop + add. The destination table is unchanged, so no downstream impact; only the source-side mapping needs to follow the rename.
-
Official comment
Hi Eliza,
This is a valuable idea and the request has been added to our feature improvements backlog. We will keep the community updated on this thread with any progress.
Thanks,
Frank
Please sign in to leave a comment.
Comments
1 comment