Hi all, having issues with some tables being displayed on Metabase.
certain portions being blacked out for confidentiality purposes
This screenshot shows the original table on Snowflake, which is perfectly fine.
However, upon being passed to Metabase, the table does not show fully - certain fields are completely empty (this screenshot is from the "Browse Data" segment of Metabase)
I went to "Ask Question" -> "Native Query" just to check again. After doing a SELECT * FROM [table_name], the same issue appears.
This is just one table, out of a few that are having the same issues - certain fields not being displayed at all. There is even one table is COMPLETELY not showing at all on Metabase, even though the table exists on "Browse Data":
Would any kind soul(s) help me out? Thank you!
Hi @jophren
Post "Diagnostic Info" from Admin > Troubleshooting.
If you are not even getting any results by using the select-query, then I would guess it's either a problem at Snowflake, or perhaps a privilege permission problem.
Have you tried to use the same credentials with DBeaver.io and the same JDBC driver version as Metabase?
hi @flamber, here is the diagnostic info
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.131 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "1.8.0_265-b01",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_265",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "25.265-b01",
"os.name": "Linux",
"os.version": "4.14.198-152.320.amzn2.x86_64",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"snowflake",
"googleanalytics"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.10"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.40.2",
"date": "2021-08-03",
"branch": "release-x.40.x",
"hash": "b884d29"
},
"settings": {
"report-timezone": "Asia/Hong_Kong"
}
}
}
Hi @jophren
Okay, then try DBeaver with driver version 3.12.13 (about a year old).
The upcoming Metabase 0.41.0 will use 3.13.6
