- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Need automatic script(Query) for JSON file
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. please let me know.
TIA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can do copy file to file or file to table into lakehouse. Can you elaborate a bit more on "automatic script"?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Grace,
below is my JSON script
and i have Json table below with name Student(for assumption)
it is having the columns of
studentId,studentName,studentBranch
and data is
101 Adam Finance
102 Scott Accounts
103 Saran Finance
104 Aantony Sales
so if you want to create the same table in SQL, you need to write one query like below
create table Student(studentId int,studentName varchar(50),StudentBranch varchar(50))
insert into Student values(
101 Adam Finance),
(102 Scott Accounts),
(103 Saran Finance),
(104 Aantony Sales)
then the same table will create in SSMS.
so @GraceGu what I want to achieve here is, that sql script i want to generate automatically from that JSON file/script. in SQL or in Python or pyspark also(in any language) that enough for me.
is there any way, please let me know. its very need for me.

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Fabric Monthly Update - June 2025
Check out the June 2025 Fabric update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
12-04-2023 06:16 AM | |||
06-18-2024 05:01 AM | |||
08-05-2024 07:06 PM | |||
08-22-2024 06:44 AM | |||
09-27-2024 06:33 AM |
User | Count |
---|---|
2 | |
2 | |
1 | |
1 |