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