"This database doesn't have any tables."

Hey all.

So we're hoping to use Metabase to do some quality assurance reporting for us, and I recently spun up a test database to play with Metabase, but I'm getting an error "This database doesn't have any tables."

And that WAS true, but I have since imported an Excel file into its very own table in that PostgreSQL 14 database, for which the Metabase database user has full privileges on, and it's still not seeing that table. We're running Metabase in its docker container and, paradoxically, it works just fine - even though the Metabase database is running in the same PostgreSQL instance that the test database I want to try some reporting from is running on. I'm not seeing any sync errors in the logs or anything!

Here's my Admin > Troubleshooting > Diagnostic Info:

{
  "browser-info": {
    "language": "en-US",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Linux x86_64; rv:131.0) Gecko/20100101 Firefox/131.0",
    "vendor": ""
  },
  "metabase-info": {
    "databases": [
      "h2",
      "postgres"
    ],
    "run-mode": "prod",
    "plan-alias": "",
    "version": {
      "date": "2024-10-02",
      "tag": "v0.50.28",
      "hash": "3179ef2"
    },
    "settings": {
      "report-timezone": null
    },
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "14.13"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.7.3"
      }
    }
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.24+8",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.24",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.24+8",
    "os.name": "Linux",
    "os.version": "4.18.0-553.5.1.el8_10.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  }
}

Logs, sanitized, are here: PrivateBin

Which permissions does the user have in the db?

All, as far as I can tell. "Ctc" in my pgAdmin 4 console.

give the user a higher role, it needs to be able to get the tables from the information schema

Okay - so I gave my Metabase PostgreSQL user "ALL" privileges (tarwdDx) on all tables, but I am still not seeing any tables, even after going to "Admin settings" > "Databases" > $myDatabase > "Sync database schema now" and "Re-scan field values now".