HOW TO CONVERT JSON DATA TO CSV BY USING THE PYSPARK CODE FOR SIMPLE JSON AND NESTED JSON IN FABRIC

# df now is a Spark DataFrame containing JSON data from "Files/data/NESTEDJSON1/NESTEDJSON1.JSON".
display(dfN)

# Flatten nested DataFrame
flattened_df = dfN.selectExpr("explode(employees) as employee") \

# Write flattened DataFrame to CSV (replace 'output_path' with your desired output path)