Fabric Notebook - Load File

You can use pipelines to load the CSV file data into your tables.
You can also try notebooks:
https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-notebook-load-data

Hi yash_robin ,

Thanks for using Fabric Community. 
As I understand you are very new to fabric and try to explore it. 

Here is a very simple code to load any csv data to table using pyspark.

df.write.format("delta").saveAsTable("gopi_lake_house.new_table")

 
Additional docs to refer -
Work with Delta Lake tables in Microsoft Fabric - Training | Microsoft Learn

Please refer above docs it will help you to get through few examples.

Hope this is helpful. Please let me know incase of further queries.