topic Fabric Notebook - Load File in Data Engineering

Fabric Notebook - Load File

yash_robin — Thu, 02 May 2024 10:45:14 GMT

Hi,

I am trying to explore fabric notebook, when I try to work with CSV files I am looking for an option to load the CSV file to table programmatically?

Thanks

Re: Fabric Notebook - Load File

MatrixMan112 — Thu, 02 May 2024 10:58:41 GMT

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

Re: Fabric Notebook - Load File

Anonymous — Thu, 02 May 2024 10:58:50 GMT

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.

Re: Fabric Notebook - Load File

Anonymous — Thu, 02 May 2024 11:45:09 GMT

Hi @yash_robin ,

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