Hello everyone,
My team and I are experiencing an issue with Metabase. We work as a duo, and each of us has our own test schema in our Snowflake database, as well as a production schema:
- DBT_ANTOINE_RENTA (my colleague's schema)
- DBT_NICOLAS_RENTA (my schema)
- DBT_PROD_RENTA (production schema)
The issue is that all our schemas in Snowflake contain 8 tables, but in Metabase, only the DBT_ANTOINE_RENTA schema appears complete. The other two schemas display only 3 tables in the database explorer.
To clarify:
- I can query the missing tables in Metabase’s SQL editor (when I run:
SELECT TABLE_NAME
FROM XXXXXXXX.INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'DBT_NICOLAS_RENTA'
all my tables appear).
- Metabase is up to date (v0.53.6).
- In Snowflake, all three schemas have exactly the same permissions (USAGE and SELECT for our Metabase role).
- No table is hidden (checked in Table Metadata).
- We've already tried synchronizing the database schema and clearing cached values multiple times.
- Tested with a different browser and in incognito mode, but the issue persists.
Any help would be greatly appreciated!
Thanks in advance