Field Filter can't map to table

Get Help
1

I am trying to set up a field filter for one of my queries. However, when I go to the "Field to map to" dropdown menu, I don't see the table I want in the database, even though I know it exists. Running "Sync database schema now" in Admin has not helped.

Is this a bug? What else could be causing the table to not show up?

2

Lots of things :wink:

What are the field settings in the metadata?

Is it the correct type? I've had problems trying to use a Text filter on ID column.

Is the field in the query already? If not, are the joins defined? Best approach is a simple star schema.

3

Thanks for responding. I'm not sure I understand.

I created a table in Snowflake. Let's call it A. I then wrote a SQL query in Metabase using that table.

Query is something like this:

select
  name,
  quantity
from A
where {{name}}

Now I would like the {{name}} filter to correspond to the name column in table A. However, when I go to the "Field to map to" dropdown, I see a list of folders (I'm frankly not sure what they represent) each containing what appear to be tables. This is where I'm stuck, because I don't see table A anywhere. I'm not sure where to find it or if I accidentally skipped a step.