Skip to main content
Panther Knowledge Base

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

QUESTION

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

ANSWER

 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

try

select json_object:my_special_field as my_field from the_table