Unable to get category filters

Get Help
1

I have synced this query in metabase as a simple question by creating a view in Bigquery.
Now I want to apply OUID as a category filter and date as relative date filter but I ain't getting any option in filters. Can anyone help?

with data1 as (SELECT D,OUID,DateVal,C FROM X), data2 as (WITH
set1 AS (
SELECT
A,
B,
C,
FROM
Y),
set2 AS (
SELECT
MAX(A),
C,
FROM
Y
Group by C )
SELECT
set1.A,
set1.C
set1.B
FROM
set1
INNER JOIN
set2
ON
set1.A = set2.A
AND set1.C = set2.C)

select data1.D,data1.OUID,data1.C,data1.DateVal,data2.B from data1 left join data2 on data1.C = data2.C

2

Hi @Bhaumik1
Post "Diagnostic Info" from Admin > Troubleshooting.
I don't understand if you have created this as a View on BigQuery or if the SQL is just a question in Metabase.
If it is a question, then you need to create filter variables, but remember that you cannot do that on table aliases: https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html

3

This is a view on BQ.

4

@Bhaumik1 Post "Diagnostic Info" from Admin > Troubleshooting.