Source DB Table Change, New Fields Added
Can someone provide an update on what happens when a new field is introduced to a table in the Source DB -- and is being synchronized to Incorta?
Will Incorta automatically identify the additional field and add it to the existing schema during the next synchronization?
It is also worth noting that Incorta, by default, lists out each field name in the SELECT statements that define each Incorta table. This is by design. By listing each field name, rather than performing a SELECT * FROM <table>, Incorta is less vulnerable to failure when a new column is added to the source system table. To Seth Luersen 's point, it still doesn't sync automatically, but this give us a more robust way to elude failure when the source system changes.Reply