Our Snowflake data warehouse has many different schemas. Right now, Metabase is only picking up the tables within one of the schema, without even recognizing any of the schemas (even the one schema these tables are from).
When looking through the logs, the following message appears: "Marking tables as inactive:" and then marks all tables from other schemas inactive.
Thoughts? Checked on Snowflake permissions and that wasn't it.
Actually, we can query the tables, they just don't appear in the database. Other schemas and tables in those schemas don't show up when browsing through the database, and don't show up as data to select when making a question.
@Luiggi looking into it, our accounts that have been updated to the new version have this error while any account still on the older version ( v0.47.9) do not.
Did something change in the new version regarding snowflake syncing? Or would cause metabase to mark whole schemas as inactive?
Our Snowflake db has, let's say, 6 schemas. Only the one called "Analytics" appears in the UI but all six can be queried in SQL. I created a new database object in Metabase and connected it to our Snowflake database with the exact same credentials as the problem object and it works fine.
And yes, this only started happening with 0.48.1. It looks like the same thing is happening to this user as well.
Is the core team aware of and working on this issue? It's been several weeks since my other Snowflake schemas have disappeared from the UI (self-hosted 0.48.3), although they can be queried via SQL…
For what it's worth, I realised that several tables in my Metabase PG database had been set to active=false. So I just combed through metabase_table and manually set active=true on the tables I needed, which now appear in the interface.
So I assume it's some kind of migration script in a recent update that forcefully hid these tables, somehow…