Invisible Tables in Metabase, Present in My Snowflake Schema

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 :slightly_smiling_face:

please check this PR and enable the logging Add describe-fields query logging by lbrdnk · Pull Request #55039 · metabase/metabase · GitHub

Thanks a lot ! we gonna check on this !