I can’t see my tables
You have connected Metabase to a database, but:
- you don’t see the tables in the Data Model section of the Admin Panel,
- the tables don’t appear in the Data Browser,
- the tables don’t show up as possible data sources when you create a query using the Notebook Editor, or
- you can no longer see tables that you used to be able to see.
Is your browser showing you a cached list of tables?
Root cause: Sometimes browsers will show an old cached list of tables.
Steps to take: Refresh your browser tab and check for your table or tables again.
Does the database exist?
Root cause: The database doesn’t exist. For example, you may have connected to a test database while doing an evaluation but are now in a production environment.
Steps to take:
- Go to Admin > Databases.
- Check that the database you’re trying to query is listed.
- Click on the database name and examine the settings.
Exactly what settings you need will depend on your environment. To test that the settings are correct:
- Try to connect to the database using some other application (e.g.,
If you can’t connect to the database with another application, the problem is probably not with Metabase. Please check that the database server is running and that you have the correct host, port, username, password, and other settings.
What’s the status of your database connection?
Root cause: You’ve configured a database connection, but it’s not working as expected.
Steps to take:
If your connection isn’t working, go to Troubleshooting database connections.
Does the table exist?
Root cause: The table you think you should be able to see does not exist (e.g., it has a different name than you expect).
Steps to take: To test that the table you are trying to query actually exists and that you have permission to access it, use the SQL Editor to create and run a query like:
select * from SOMEWHERE
SOMEWHERE is the table you think you should be able to see. Metabase should display an error message like:
Table "SOMEWHERE" not found
If you see this message, use another application (e.g.,
psql for PostreSQL) to send the same query to the database. If it also produces a “table not found” message, check the database schema and the spelling of the table name.
Be sure to log in to the database using the same credentials that Metabase uses. A common problem is that the account Metabase uses to connect to the database lacks the same privileges as a member of IT staff or a developer, so tables that are visible to the latter when they use external applications are invisible to Metabase. You may want to check if Metabase has the correct permissions.
Does the person who cannot see the table have permission to view it?
Root cause: Metabase uses a group-based permission model: people belong to groups, and administrators can set permissions so that some groups cannot see all of the tables.
Steps to take:
- Log into Metabase using the ID of the person who cannot see the expected tables.
- Confirm that the tables are not visible.
- Log out, then log in using the administrator’s credentials.
If the administrator’s account can see the tables but an individual person cannot, see [Troubleshooting permissions][troubleshooting-permissions].
Is Metabase’s metadata out of sync with the state of the database?
Root cause: In order to display available tables and columns in dropdown menus and previews, Metabase runs a query every hour to find out what tables are available and what columns are in each available table, and stores this information in its application database.
- If a table has been added or removed since the last time this “sync” operation ran, Metabase’s information about the database will be outdated.
- In some rare cases Metabase may time out while synchronizing with the database. For example, if you’re using MongoDB and have very large (hundreds of kilobytes) JSON blobs, the sync operation may not complete in the allowed time.
Steps to take:
- Run the “sync” process manually:
- Go to Admin Panel > Databases.
- Choose the database.
- Click on “Sync database schema now”.
- Go to Admin > Troubleshooting > Logs and see if there are any error messages saying that the “sync” operation could not run (e.g., because the network or the database itself was temporarily down).
- If there are no suspicious error messages, log out of Metabase, close the browser tab, log back into Metabase in a new browser tab, and try to access your table again.
- My data sandboxes aren’t working.
- I can’t view or edit a question or dashboard.
- My visualizations are wrong.
Are you still stuck?
If you can’t solve your problem using the troubleshooting guides: