-
Using Vector to store Kong logs in ClickHouse
Today we will explore how to store Kong logs in ClickHouse using Vector. TL;DR Clone the demo in https://github.com/pachico/demo-kong-vector-clickhouse and follow instructions or keep reading for some notes. Overview Kong is the de-facto standard for API gateway solutions (sometimes also called API management).
Read more… -
ClickHouse: MongoDB as source for dictionaries
Let’s talk today about how MongoDB can be used as source for ClickHouse external dictionaries. This is a pretty recent and powerful feature that you can now explore by simply downloading the demo.
Read more… -
ClickHouse: S3 table functions
Today I want to explore with you how to import and export data from and to S3 using ClickHouse. We will also use ClickHouse’s greatCircleDistance() function to calculate the distance between a set of coordinates and all the cities in GeoNames free gazetteer.
Read more…