Hi,
We have a system where the source table undergoes changes (mostly adding new columns) often. Even though it has been recommended not to do that frequently, certain teams do it and I'd like to know with our incremental load in ADF , is there a way to dynamically add those new columns even when i'm not aware and also perform its regular upserts . Is this possible, without me having to drop and recreate the table everytime.
Thanks in advance.