Step 1: Please block duplicated columns and not arbitrarily choose one. We risk exposing unwanted sensitive information at current state. 

Step 2: Give user a programmatic way to choose which column to use. With 400 connectors, using UI is not sustainable. Please give us a way to scale with Fivetran.