topic Csv Python Fabric in Data Warehouse

Csv Python Fabric

Msoede — Wed, 22 Jan 2025 13:04:34 GMT

Hi,

Hopefully someone can help me out with the following. I want to create a csv file from a query in Fabric (being to big for Excel). Do I need to create such a csv with Python or are there other possibilities? Could someone help me out with a script to extra data to csv from Fabric?

Many thanks,

Michiel

Re: Csv Python Fabric

nilendraFabric — Wed, 22 Jan 2025 17:45:35 GMT

Hello Msoede

Please give it a try:

df = spark.sql("YOUR SQL QUERY HERE")

# Save the Spark DataFrame as a CSV file
df.write \
.option("header", "true") \
.option("delimiter", ",") \
.mode("overwrite") \
.csv("/lakehouse/default/Files/your_file_name.csv")

Re: Csv Python Fabric

v-menakakota — Thu, 23 Jan 2025 06:50:08 GMT

Hi Msoede ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

You can create a CSV file from a query in Fabric
Providing the reference thread which may assist you in addressing the query:
Solved: save data to .csv - Microsoft Fabric Community

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Regards,
Menaka