By default, metabase supported the following databases,
- SQL Server
- Google BigQuery
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. If your business ever loses its data, then you may need to buy disaster recovery services to recover it.
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.