JSON extract in trino

Technical queries
, , ,
#1

Hello Helical Insight,

I am using helical insight version 5.0 GA. And I want to extract data which is in JSON format. How can that be done?

Thank you,
Netta.

#2

Hello Netta,

Hello ,

You can extract data which is in JSON format. Below is the syntax which will give you some idea on how to extract data.

Create a custom Column and can extract the value based on the key(name)

“citationdata”.notification_audit_trail[1].doc_location
“citationdata”.notification_audit_trail[1].notification_type

Thank you,
Helical Insight.