Data Warehouses with ClickHouse and Ruby
Every organization that produces large amounts of data needs a way to analyze that data efficiently. Traditional transactional databases can be very slow when we have to crunch terabytes of historical records. For this purpose we can use OLAP databases such as ClickHouse.
In this talk we will review key data warehousing concepts, I will present the benefits of using ClickHouse to build reporting systems and we will see how we can use Ruby to load and query the data. I will also share the main technical challenges we have encountered at Verve Group building our reporting system using ClickHouse and Ruby.