No data returned from Clickhouse


I have had Metabase successfully connected and querying Druid and am looking at using Clickhouse as it might suit our purposes better ... but after setting up the conenction to Clickhouse I can see the dbase and the table and model .. but any exploration or query just returns a 'No data' response. Running the same queries in the clickhouse web app returns the expected data, as does the cli. User has access to the database. Nothing in the metabase log for an error ... stumped as to what the cause is or where to look next.



Hi, can you post diagnostic info?

Here's what the Diagnostic Info reports screen reports
"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/ Safari/537.36",
"vendor": "Google Inc."
"system-info": {
"file.encoding": "UTF-8",
"": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.16+8-post-Debian-1deb11u1",
"java.vendor": "Debian",
"java.vendor.url": "openjdk-11 - Debian Package Tracker",
"java.version": "11.0.16",
"": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.16+8-post-Debian-1deb11u1",
"": "Linux",
"os.version": "5.10.0-16-amd64",
"user.language": "en",
"user.timezone": "Australia/Melbourne"
"metabase-info": {
"databases": [
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
"run-mode": "prod",
"version": {
"date": "2022-11-01",
"tag": "v0.44.6",
"branch": "release-x.44.x",
"hash": "5c6ae21"
"settings": {
"report-timezone": null

Can close this ... not sure why but I created a new user and database and redid the ingest and now that user gets data returned. Maybe something wrong with default perms on previous user.