Need to create automatic script from JSON file

[sudhav]

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]

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]

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