Skip to main content
Panther Knowledge Base

Can I have a Saved Query in Panther with a JSON selector in it?


 How do I used JSON selectors in my Saved Queries if Panther doesn't allow column named with a colon (:)?


 To use a colon as a JSON selector in Panther Saved Queries, you must alias the column name. For example, instead of

select json_object:my_special_field from the_table


select json_object:my_special_field as my_field from the_table