Hello, I'm totally new to the metabase, and I'm not getting my variables and filters working together. The FULL_NAME column is a list of names I'd like to use as a filter for my two questions on the dashboard.
Your problem is in the last line of your SQL. It should be [[WHERE {{FULL_NAME}}.
This is because field filters, in contrast to “normal” variables, insert a SQL snippet rather than just a value. So in your case, that variable is being replaced with the snippet J.FULL_NAME=(whatever the selected value is). This is so that you can map the variable to a specific field, and so that Metabase can present richer filter widgets that let your users select operators other than =, like “starts with” etc.
I hope that helps!