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