Metbase Field Filter Fields update failure

Bug reports
1

Hello Team I am currently facing challenges when I create a new table in snowfalke (connection already established with Metabase) and try to access the fields using field filter. Once the table is created in Snowflake it reflects well in Metabase but the table is not shown under field filter when I try to use it in a variable in Metabase SQL. There is not problem with the query that I am writing.

I have done the following troubleshooting steps but yet the problem did not get resolved:

  1. Went to Admin Portal
  2. Databases -> Selected the database -> Sync database schema now
  3. After 15 to 20 mins tried -> Re-scan field values now
  4. After sometime tried Table Metadata -> Selected the Schema -> Selected the table -> Settings -> Re-scan this table

I have faced this problem earlier too, usually it take 10 to 12 hours to get the table updated in the field filters but that should not be the cases as I am manually triggering it.

Can you help me with this issue?

2

Did you go through the tables and set the semantic types for the fields? Field Filter needs to know what sort of data is in the column so it knows what types of filter it can apply.

1 Like
5

Usually I do not put any sementic type, it is auto read by metabase for all data types. I believe that is not the problem but there is some trigger not happening on field filter even if I do the above mentioned process automatically. Therefore it requires 12 to 14 hours to reflect.

6

Sounds like it needs the fingerprinter to run then. Can you check the log and see if the fingerprinting process ran between the time you created the table & rescanned the database and when you can successfully create the field filter? That would imply Metabase needs a button to start that process manually.

7

I have checked the tasks and saw that fingerprint-fields ran along with sync-metabase-metadata and this is the output

image
image1118×248 16.1 KB