How to change the data type on mapping?

Hi abhidotnet ,
Thanks for using Fabric Community to post your query.

Thanks suparnababu8 for your prompt response.

Currently, when an additional column is added directly in the source tab of the Copy Data activity, the UI does not provide an option to explicitly define or override the data type. In such cases, the system may infer the column as a string by default, even if the value appears numeric.

In the scenarios you’ve seen in youtube videos, it’s possible that the column was added at an earlier stage , such as within a Lakehouse view or Dataflow , where the data type was already strongly defined. This typically results in the correct type being reflected automatically in the mapping screen.

As a workaround, defining the column in the Lakehouse itself (for example, via a view) and then using that as the source in your pipeline can help ensure more consistent behavior during mapping.

Hope this helps. Please reach out for further assistance.
Please consider marking the helpful reply as Accepted Solution to assist others with similar issues and a kudos is always appreciated.
Thank you.