Does Fivetran Map a Recreated Custom Fields to the Original Destination Column?
Question
If I delete a Kantata custom field and recreate it with the same name, will Fivetran map it to the original destination column?
Environment
Connector: Kantata
Answer
If the recreated field has the same name and data type as the deleted field, we map it to the existing destination column and resume syncing data to that column. If the fields don't match, re-sync the affected table to align the destination data with the recreated field. To learn how, see How to Trigger Historical Re-Syncs.
For more information on how we handle a deleted column before it's recreated, see What Happens When a Column Is Deleted From a Table in the Source?