What Happens if a File Contains Multiple Columns With the Same Name?

Question

What happens if a file contains multiple columns with the same name?

Environment

Connector: Google Drive

Answer

If a file contains multiple columns with the same name, we overwrite the values of earlier columns with those from the most recently read column. As a result, only the values from the most recently read column will be retained in the destination.

For example, if the first and tenth columns share the same name, only the values from the tenth column will be written to the destination.