I have a table that I'll update with multiple inputs (csv). Is there a simple way to update my target when the source fields won't be a 1:1 match? Another challenge I've run into is that my sources don't have a header field, though I guess I could rename the columns if this would be beneficial.

At this point, I've created a blank dataframe based on a schema and then tried to .copy the source columns into the empty df. However, when I do this I get a warning from DB telling me that this is inefficient.

Any help greatly appreciated.