topic Re: Need to create automatic script from JSON file in Dataflow

Need to create automatic script from JSON file

sudhav — Mon, 17 Jul 2023 10:50:31 GMT

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

Re: Need to create automatic script from JSON file

HimanshuS-msft — Sun, 30 Jul 2023 18:01:19 GMT

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

Re: Need to create automatic script from JSON file

miguel — Mon, 31 Jul 2023 17:12:10 GMT

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