Need to create automatic script from JSON file

sudhav · ‎07-17-2023

Hi Team,

I have a JSON file, I need automatic script in sql/python for that file, so that i can run that code in my pipeline to copy that file to my Lakehouse, is there any way to do that.

please let me know.

TIA

miguel · ‎07-31-2023

the only consideration for the dataflow is that you wont be saving a file, but actually reading the file and saving the results as a table in the lakehouse. If your intent is to save the file in your lakehouse, then you can still use the copy activity in data pipelines

HimanshuS-msft · ‎07-30-2023

Hello @
Thanks for using the Fabric community.
If the intend is to copy the content of the JSON to LakeHouse , havre you tried to use the data flow ?
If you are facing any issue , please do let me know .

Thanks
HImanshu