Clickhouse

ClickHouse is an open-source column-oriented DBMS for online analytical processing. ClickHouse was developed by the Russian IT company Yandex for the Yandex.Metrica web analytics service.

There are roughly two kinds of queries allowed in Clickhouse:

1. API based (not supported by airbyte)
2. JDBC based (used by airbyte). For more details please follow this link.

Also make sure to read the documentation in its entirety to have a strong understanding of this important aspect of the product.