topic Re: Copy Activity - On Prem to Lakehouse :: Additional Columns in Pipelines

Copy Activity - On Prem to Lakehouse :: Additional Columns

netoferraz — Fri, 19 Apr 2024 20:47:26 GMT

I've been attempting to include extra columns during the copy operation, but they're not being included in the destination (Lakehouse). I've experimented with various approaches:

Utilizing the Data Pipeline feature within the Source tab.
Opting for a custom query instead of selecting the table directly to append that supplementary information to my copy operation.

Unfortunately, neither of these methods has succeeded in adding the extra columns to the original table that was copied. Is this the expected behavior when transferring data from On-Premises to a Lakehouse?

Re: Copy Activity - On Prem to Lakehouse :: Additional Columns

Anonymous — Mon, 22 Apr 2024 10:30:39 GMT

Hi netoferraz ,

Thanks for using Fabric Community.

Can you please click on import schema after adding Additional Column?

Can you please try above steps and help me know the result?

Hope this is helpful.

Re: Copy Activity - On Prem to Lakehouse :: Additional Columns

netoferraz — Mon, 22 Apr 2024 11:33:38 GMT

Thank you Anonymous ! It worked! The missing part was to import schemas in the mapping tab.

Re: Copy Activity - On Prem to Lakehouse :: Additional Columns

Anonymous — Mon, 22 Apr 2024 18:22:44 GMT

Hi netoferraz ,

Glad to know that your query got resolved. Please continue using Fabric Community on your further queries.