That's the question, short of treating the initial copy into as a temp table and executing a merge statement after it into another table where we can do the add, update type operations is there another option - with COPY INTO or AUTOLOADER or DLT - that would automatically handle changes within a source file where that file modified date changes?

We're open to modifying the process just seeking to understand options.