Cannot use string filters on foreign keys

I have checked discourse and github, sorry if it's still a duplicate

When trying to filter on a text column that happens to be declared as a foreign key to another column, the UI only offers me the Is and Is not options.

Screenshot 2024-03-22 at 13.31.37

Notably, it lacks the contains, starts with, is empty, ... filtering options that are generally available for text columns:
Screenshot 2024-03-22 at 13.34.36

I've also tried to modify the Filtering on this field config of the table, but nothing fixes it.


  1. This is on Metabase v0.49.1, using a BigQuery connection.
  2. I tried and could not reproduce the issue on the Sample Database :confused: