I'm having a big problem: my database, PostgreSQL, is linked to Metabase, but recently when I added some new tables, the Metabase stopped displaying them. How can I fix this? Please help me!
In PostgreSQL, new tables start out accessible only by the table creator. You will need to grant the Metabase database user (or PUBLIC) permission to read the table. Use the GRANT command to grant the SELECT permission to the Metabase database user:
GRANT SELECT ON mynewtable TO metabase;
Or, if you’re okay with all database users reading the table:
GRANT SELECT ON mynewtable TO PUBLIC;