Make a table in my lakehouse from a csv file

[BenLyon]

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

[spencer_sa]

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.

[BenLyon]

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

[spencer_sa · Accepted solution]

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.