Hello @Tran, Hoa ,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is know how to use the JSON.parse , please do let us know if its not accurate.
Just to let know that the JSON.parse function is to be used to query Azure SQL data streams .
Azure SQL Database as reference data in your job, it's possible to have a column that has data in JSON format. An example is shown below.
I did went ahead and looked into the JSON which you shared
If we try to query this , we get
Select value.vrms from Input
If ths json is updated to
Select value.vrms,value.apeak from Input
Please do let me if you have any queries.
- Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators