Can I have a Saved Search in Panther with a JSON selector in it?
Last updated: September 3, 2024
QUESTION
How do I use JSON selectors in my saved searches if Panther doesn't allow column named with a colon (:)?
ANSWER
To use a colon as a JSON selector in saved searhces, 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