I have hidden some schemas long back and unable to unhide it now. Can someone help me to unhide the schemas?
Hi @havala
You cannot hide schemas currently. You can hide tables within a schema.
https://www.metabase.com/docs/latest/administration-guide/03-metadata-editing.html#table-visibility
Thank you
But few schemas are not visible in the metabase!
What could be the reason?
Do you have any idea?
@havala
Post "Diagnostic Info" from Admin > Troubleshooting.
Most likely caused by the database credentials that you are using in Metabase (Admin > Databases) does not have privileges to those schemas.
https://www.metabase.com/docs/latest/troubleshooting-guide/cant-see-tables.html
Hi @havala
Try making a query in Metabase for a table inside of a missing schema:
select * from missing_schema.some_table
@havala Like I said originally:
Most likely caused by the database credentials that you are using in Metabase (Admin > Databases) does not have privileges to those schemas.
Ask you database administrator to grant permissions to the schemas for the user used in Metabase Admin > Databases.
Hi Thank you very much.
I gave grant permission.
Now I can query the data, from the table. But I cannot see the schema name in Data model.
How can I get it?
@havala Metabase has to sync first.
Do a manual sync via Admin > Databases > (your-db) > Sync database schema now.
Follow along in Admin > Troubleshooting > Logs.
https://www.metabase.com/docs/latest/troubleshooting-guide/sync-fingerprint-scan.html