Easy and Effective Way of Building External Dictionaries for ClickHouse with Pentaho Data Integration Tool (opens in new tab)

In this post, I provide an illustration of how to use Pentaho Data Integration (PDI) tool to set up external dictionaries in MySQL to support ClickHouse. Although I use MySQL in this example, you can use any PDI supported source. ClickHouse ClickHouse is an open-source column-oriented DBMS (columnar database management system) for online analytical processing. Source: wiki. Pentaho Data Integration Information from the Pentaho wiki: Pentaho Data Integration (PDI, also called Kettle) is the co...