400 Bad Request POST

i am facing an issue in metabase, if i try to apply a filter, it is throwing
i even gave full reference of the table and also resync of table was done.

ERROR:
400 Bad Request POST https://bigquery.googleapis.com/bigquery/v2/projects/dev-project-431208/queries { "code": 400, "errors": [ { "domain": "global", "location": "q", "locationType": "parameter", "message": "Unrecognized name: data_flow.landinfos_clustered_fixed at [8:8]", "reason": "invalidQuery" } ], "message": "Unrecognized name: data_flow.landinfos_clustered_fixed at [8:8]", "status": "INVALID_ARGUMENT" }

should you be including dev-project-489483 there? Did you try using the GUI Editor, are you able to query there and then turn the GUI to SQL so you can see the proper syntax

hello,
dev-project-489483 is included to give full reference of the table,
and when i try build same in GUI i don't need to specify WHERE clause since it automatically takes all columns to filters

What i mean is for you to first start from a GUI and then convert to SQL

Since it's clear something in your Syntax isn't right

Thanks for responding but just a doubt,
if i convert question to native query then I need to again mention field filter syntax right?
Also I have to use native query itself as base because for simple queries question to native query works which you mentioned, but for complex grouping i need to use native query as base

What i simply mean is to check the SQL Syntax metabase generates cause i think you have something wrong in yours

Can you just share a screenshot of the SQL syntax that metabase generates?

correct project id is this [dev-project-431208] and same was used in query, i just changed the number to take screenshot,
and this issue happens only if i select any value in filter and query will work if i don't select any value in filter