Field Filter (SQL) Field to Map to not showing the right table

We are building a question in SQL and we want to use field filters to pull values from a column in the table we are querying. When we select field filter though, it offers us all other tables from the data source except the one we are querying on. I'm fairly certain I've done these types of questions in the past and never had this happen.

Our data source is clickhouse if that makes a difference

Diagnostic info

{
  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "metabase-info": {
    "databases": [
      "h2",
      "clickhouse",
      "postgres"
    ],
    "run-mode": "prod",
    "plan-alias": "starter",
    "version": {
      "date": "2024-10-15",
      "tag": "v1.50.30",
      "hash": "a49cb77"
    },
    "settings": {
      "report-timezone": null
    },
    "hosting-env": "unknown",
    "application-database": "postgres"
  }
}

There should be 'Ads' as a table showing which is what we are running the query on.

please contact support