Error - Mapping Sink is Empty.

Hi abhidotnet ,

I have tested and when executing map column in data pipeline, the data pipeline may report an error if it is two different tables with mismatched column names or data types.

Here are some of my suggestions:

Columns in both tables should have similar or same names. This will make it easier for the mapping rules to recognize and match the columns.

The data types of the columns involved in the mapping should be the same or compatible. For example, an integer column in one table can be mapped to an integer column in the other table, but not to a string column.

Manually specify which columns are to be mapped in the mapping configuration, even if they have different names.

Preprocess the data so that the column names and data types are as similar as possible before performing the mapping.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!