I have some issues with upgrading Matabase and ClickHouse and need help

Get Help
1

I'm facing a problem now. I am using matabase for BI reports now. And the OALP engine is clickhouse.

Now I want to upgrade the version of matabase to 54.x or 55.x.

But I see the version of metabase-clickhouse-driver now is 1.53.4. And The JDBC driver was updated to 0.8.4.

And the 0.8.4 jdbc driver is jdbc-v2.

Now my matabase version is 0.52.3. Clikhouse version is 21.2.2.

So I want to know. To upgrade the version of metabase, I need to upgrade the version of metabase-clickhouse-driver.

I want to know if the V2 version of the jdbc driver is compatible with the 21.2.2 version of clickhouse？

If it is not compatible, I need to upgrade the version of clickhouse, but I don't know which version to upgrade to.

Which version will make the upgrade process simpler and more stable, and upgrade the jdbc driver that supports version 2?

3

As of Metabase 54, the Clickhouse driver ships with the app and metabase-clickhouse-driver is no longer used. So yes, it will make the upgrade process simpler.

4

Does version 54 of Matababase support version 21.2 of ClickHouse?

5

I don't see any minimum version requirement in the documentation, so let's say "yes" until proven (or informed) otherwise.

21.2 is a very, very, VERY old version though -- over 4 years old, released in February 2021. If there's issues you're not likely to get much support.

6

Ok， thank you very much, I decided to upgrade the version of clickhouse to 25.x。
By the way，My current matabase dashboard is based on clickhouse.
If I have the same data table in my doris cluster.
If I want to switch all the data sources of all the dashboards to doris, do you think it is possible? Or do you have any experience to share? Are there any official capabilities of matabase that I can learn from? Thank you。

7

It's technically possible to connect to a Doris database using Metabase's MySQL driver, but Doris isn't 100% compatible with MySQL and Metabase may run into issues. There's a few issues logged in the Doris github. There is also a third-party Doris driver on github which may improve the integration.

On top of that, you would need to rebuild the dashboards that you are changing the data sources for. There's no capability to change the data source for a dashboard programmatically at current.