Zero schemas are appearing in Table Metadata, and when trying to access tables using the Browse section a message appears saying "This database doesn't have any tables." However, I can query tables directly when creating a new SQL query, and I am able to view these tables in Snowflake when using the same role that is granted to the Metabase user. When I try to access an existing question or query, there is an error message saying "Table xxxx is inactive.", but I don't know how it was set to inactive.
We just upgraded to version 0.50.23 from 0.49.3 on August 30th.
We have tried manually syncing a few times and there doesn't seem to be any issue doing so, which makes sense given I can query the data - we just can't browse it or view any questions. There is no message in the logs about marking tables inactive.
Diagnostic Info:
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"metabase-info": {
"databases": [
"snowflake"
],
"run-mode": "prod",
"plan-alias": "",
"version": {
"date": "2024-08-29",
"tag": "v0.50.23",
"hash": "7040ff1"
},
"settings": {
"report-timezone": null
},
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "16.1"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.7.3"
}
}
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.24+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.24",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.24+8",
"os.name": "Linux",
"os.version": "5.10.220-209.869.amzn2.x86_64",
"user.language": "en",
"user.timezone": "UTC"
}
}
