Looker Filter Suggestions not passing Parameter into Query

[matt_jackman-16]

We’ve just started experiencing an error on the Filter Suggestions call when trying to pull up suggestions in Looker.

We have a table that is partitioned by date, so we always pass a date value (via a parameter in the sql_always_where clause) into the explore to ensure only a single date is selected. This works great for the Looks/Dashboards, but recently our suggestions stopped working on our explores.

The API response indicates that the date partition is not being satisfied because the query that is being generated to pull back the unique suggestions is not capturing injecting the date parameter value into the sql for the suggestion query.

It’s like this on the Look Query:

select status
from account
where account.date = cast(TIMESTAMP(‘2023-02-06 00:00:00’) as date)
group by 1
limit 500

The bolded date value is from our parameter selection.

It looks like this on the suggestion query:

select status
from account
where account.date = cast(NULL as date)
group by 1
order by 1
limit 1000

You can see that the suggestion query is not picking up the user parameter.

Any ideas?