Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
netoferraz
New Member

Copy Activity - On Prem to Lakehouse :: Additional Columns

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:

  1. Utilizing the Data Pipeline feature within the Source tab.

  2. 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?

 

 

1 ACCEPTED SOLUTION
v-gchenna-msft
Community Support
Community Support

Hi @netoferraz ,

Thanks for using Fabric Community.

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

vgchennamsft_0-1713781759525.png

 

vgchennamsft_1-1713781772182.png

 

vgchennamsft_2-1713781786966.png


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

Hope this is helpful.




View solution in original post

3 REPLIES 3
v-gchenna-msft
Community Support
Community Support

Hi @netoferraz ,

Thanks for using Fabric Community.

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

vgchennamsft_0-1713781759525.png

 

vgchennamsft_1-1713781772182.png

 

vgchennamsft_2-1713781786966.png


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

Hope this is helpful.




Thank you @v-gchenna-msft ! It worked! The missing part was to import schemas in the mapping tab.

Hi @netoferraz ,

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayFBCUpdateCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.