Updated SQL question doesn't provide new/changed columns for filtering?

Get Help
1

Hello ,
I have a question in SQL and now updated that question in order to get more and different columns and data.
Now it happens that when using this question to start with in the query builder, although I see the new columns in preview tables, I cannot select them for filtering or summarizing:

grafik
grafik1315×730 63 KB

Even after several times updating the SQL question with renaming/adding/removing columns, I cannot get all columns to show up...
Is there any cache to clean, to reread or something like that? Discarding saved field values and 'Re-scan field values now' on the database did not help either...
I am running version 0.44.5

greetings

{
  "browser-info": {
    "language": "de",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36 Edg/107.0.1418.35",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "Cp1252",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "17.0.3+7",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "17.0.3",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "17.0.3+7",
    "os.name": "Windows Server 2016",
    "os.version": "10.0",
    "user.language": "de",
    "user.timezone": "Europe/Berlin"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "sqlserver"
    ],
    "hosting-env": "unknown",
    "application-database": "h2",
    "application-database-details": {
      "database": {
        "name": "H2",
        "version": "1.4.197 (2018-03-18)"
      },
      "jdbc-driver": {
        "name": "H2 JDBC Driver",
        "version": "1.4.197 (2018-03-18)"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2022-10-17",
      "tag": "v0.44.5",
      "branch": "release-x.44.x",
      "hash": "29fab4d"
    },
    "settings": {
      "report-timezone": "Europe/Berlin"
    }
  }
}
2

Hi @mmoole
You need to run the SQL question, so it gets updated metadata, then you should be able to see the new columns if you make a new question based on that (Saved Questions).
Some browsers might be caching a request, so try refreshing the browser.

1 Like
3

thanks a lot - it seems, the browser did much caching!