This database doesn't have any tables

Get Help
1

I installed the latest Metabase.app v0.37.0.1 on MacOS 10.14.6 and I’m trying to connect to PostgreSQL DBs – one local, the other remote – both version 13.0. I could configure both and can “ask questions”, run native queries, etc.

But the one thing that doesn’t seem to work and that still throws me off is that no tables seem to be recognised under “Browse Data”. I would expect the tables of my DBs to show up there, but it says “This database doesn’t have any tables.”

Why is that? Are certain tables excluded by default?

2

Hi @cstork
Depending on how large your database is, it can take some time for the sync-process to complete, so until that is done, then tables won’t show up.
Check the log for progress - Admin > Troubleshooting > Logs
And you can do manual sync/scan via Admin > Databases > (your-database)

3

Hi @flamber,

thanks for your reply. I noticed that I have some foreign tables in these DBs and the logs show that these lead to time-outs.

However, I would have assumed that Metabase’s first step would be reading in the DB schema (i.e. table meta information, etc.) without trying to access any contents and to populate the ‘Our Date’ page with that. I assume that’s what happens when I click the Sync database schema now Action under Admin > Databases > (my-db) and it’s what the log entry

... INFO metabase.sync.util STARTING: step 'sync-tables' for postgres Database 3 'my-db'

refers to, correct? Beyond that does Metabase try to read (and cache?) table content even for views and foreign tables?

Anyway, I just upgraded to version 0.37.0.2 and now the tables are showing up. So that’s good, I guess. :slight_smile:

4

@cstork Okay, so it sounds like you had tables, where there wasn’t select-privileges, which was fixed in 0.37, so Metabase now correctly checks that and doesn’t cause the sync-process to break.
https://github.com/metabase/metabase/pull/10892 - covers a handful of issues

The first sync process will also try to fingerprint the columns, so it knows what the field can be used for (binning etc).
There’s more details on sync+scan here:
https://www.metabase.com/docs/latest/administration-guide/01-managing-databases.html#database-sync-and-analysis

8

@flamber
I have connected Metabase to a SQL server. The database has around 200 hundred tables. but, after it gets connected the Metabase shows " This database doesn't have any tables"
I tried to reconnect the database and this time I selected the "let's explore the database" option. Now, it's been two days and it's showing "The Metabase is doing science" -_-

9

@nkimran94

  1. Post "Diagnostic Info" from Admin > Troubleshooting.
  2. Check this guide: https://www.metabase.com/docs/latest/troubleshooting-guide/sync-fingerprint-scan.html
  3. Check the logs for errors during sync - Admin > Troubleshooting > Logs.
10

@flamber
1.Diagnostic info
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.13+8",
"os.name": "Windows 10",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "Asia/Dhaka"
},
"metabase-info": {
"databases": [
"h2",
"postgres",
"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": "2021-10-21",
"tag": "v0.41.1",
"branch": "release-x.41.x",
"hash": "76aa4a5"
},
"settings": {
"report-timezone": null
}
}
}