Hi, I am using Looker 4.12 and Google BigQuery standard SQL. Initially I am seeing just looker_array_sum UDF created by Looker when there is many-to-many join or 1-many join to get unique records but somehow now it is showing one new UDF (approx_percentile_distinct_disc) not sure what it does as not seeing it in final select statement of the look. I serached online but did not find any documents related to this. Can you please help me and is there a way to avoid this UDF to comming up in the SQL?
Following is the syntax cooming up in Look SQL
CREATE TEMP FUNCTION approx_percentile_distinct_disc(a_num ARRAY, fraction FLOAT64)
RETURNS FLOAT64 AS ((
row_number() OVER (ORDER BY CAST(REGEXP_EXTRACT(num, ‘\|\|(\-?\d+(?:.\d+)?)$’) AS FLOAT64)) - 1 as rn
, CAST(REGEXP_EXTRACT(num, ‘\|\|(\-?\d+(?:.\d+)?)$’) AS FLOAT64) as num1
FROM UNNEST(a_num) num
rn = CEIL(ARRAY_LENGTH(a_num) * fraction) - 1