400 Bad Request POST

[Ananth]

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" }

[TonyC]

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

[Ananth]

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

[TonyC]

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

[Ananth]

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

[TonyC]

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?

[Ananth]

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