Easy Way to Let Metabase Support More Databases

By default, metabase supported the following databases,

  • Postgres
  • MySQL
  • Druid
  • SQL Server
  • Redshift
  • MongoDB
  • Google BigQuery
  • SQLite
  • H2
  • Oracle
  • Vertica
  • Presto
  • Snowflake
  • Spark

but If I have another database, for example ClickHouse,One of the Fastest Column DBMSs, how can I do?

The answer is FDW(Foreign Data Wrappers) or SQL/MED (SQL Management of External Data) .

In 2003, a new specification called SQL/MED (“SQL Management of External Data”) was added to the SQL standard. It is a standardized way of handling access to remote objects from SQL databases. In 2011, PostgreSQL 9.1 was released with read-only support of this standard, and in 2013 write support was added with PostgreSQL 9.3.

In English, you can use Postgres to connect other database and use it as Postgres.

For example, I want to use Clickhouse with metabase,

in general, we need a clickhouse driver for metabase(there exists one, but does not support the last version metabase). so we can test it in another way.

ClickHouse is an open source column-oriented database management system capable of real time generation of analytical data reports using SQL queries.

with clickhousedb_fdw, we can easily access clickhouse through metabase.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.