Forum Discussion
Csv Python Fabric
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
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")
2 Replies
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")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 CommunityIf 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
