I want to be able to drag and drop all the columns in the input schema into the Target Path in Mapper.
If you select Pass through above the table , all fields will be included. Not visibly in the table, but they will be in the output.
You can do that, just select all the fields and drag them. See this video to see an example of how.