Error running query: Unsupported operator in JSONPath: *

so, trying to use a parsing function for extracting a json file with matching keys and I got this error instead of the same results below.

function:

$.phoneNumbers[*].type

expected results on the right:

redash output:

  1. What version of Redash are you using? How did you install it?
  2. What kind of data source are you using?
  1. I currently work on redash version 8 but i was not the one who installed it.
  2. Data source is is from google cloud (BQ).

What might be the possible causes that needs to be addressed for this to be resolved?

This is an issue with BigQuery not Redash. Your exact example was posted to StackOverflow more than two years ago.