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.
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.