topic Make a table in my lakehouse from a csv file in Data Engineering

Make a table in my lakehouse from a csv file

BenLyon — Fri, 13 Dec 2024 15:34:24 GMT

Hello

I want to create a table in my lakehouse from a csv file whitch is in the my lakehouse's files'section

Thank you

Re: Make a table in my lakehouse from a csv file

spencer_sa — Fri, 13 Dec 2024 15:57:27 GMT

Several ways of doing this, but the easiest is from the Lakehouse Files section right click on the file (or use the ... to the right of the file's name) and click 'Load to Tables'

Select New Table, give it a name, and make sure the separator is correct.

If this helps, please consider Accepting it as a Solution.

Re: Make a table in my lakehouse from a csv file

BenLyon — Fri, 13 Dec 2024 16:40:45 GMT

Hello,

This solution count not be automatised.

I want to know if i can use a copy data in a pipeline to create my table in my lakehouse.

Thank you

Re: Make a table in my lakehouse from a csv file

spencer_sa — Fri, 13 Dec 2024 23:40:22 GMT

A copy data activity in a pipeline is the second easiest method and can be automated
If you're using the Copy Activity Assistant it takes you through each of the steps.
Set the source up:

Set the destination up, changing types where needed:

You can then save the pipeline and run it manually or on a schedule.

If this helps, please consider Accepting it as a Solution so others can find it more easily.