Hi everyone
I'm trying to setup a dashboard with some FieldFilter in order to let the user filter the value.
Here it is my query:
SELECT *
FROM "dm_demo_insurance"."crashs_summary"
where 1=1
[[and crashtimestamp = {{crashtimestamp}} ]]
[[and speed = {{speed}} ]]
[[and intensity = {{intensity}} ]]
[[and crashtype = {{crashtype}} ]]
the main problem is this:
Once i click on a field filter and select an option, the widget stop working completely and i get this message:
[Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. line 9:100: mismatched input ')'. Expecting: <expression> [Execution ID not available]
Seems query not matching correctly the field filter or sort of.
Currently im running metabase on docker.