Set up Clickhouse database for Kafka Streaming | Data Steraming | OLAP database | Clickhouse

In this video we will cover a columnar database called clickhouse. We will use Clickhouse as the target database for our Apache Kafka streaming. This will be a perfect match for our stream processing application and real-time data anlaysis. A columnar database is optimized for fast retrieval of columns of data, typically for an analytical application. ClickHouse® is a high-performance, column-oriented SQL database for online analytical processing (OLAP). It has open source and a cloud base offering. You can use Clickhouse if you need real-time response over a large dataset. Link to Clickhouse docs: #why-is-clickhouse-so-fast Like to GitHub repo: 💥Subscribe to our channel: 📌 Links ----------------------------------------- #️⃣ Follow me on social media! #️⃣ 🔗 GitHub: 📸 Instagram: 📝 LinkedIn: 🔗 @hnawaz100 ----------------------------------------- #clickhouse #kafka #etl Topics covered in this video: ================================== 0:00 - Introduction to Clickhouse 0:27 - Row vs Columnar database 2:14 - Clickhouse Set up 2:23 - Docker-compose overview 2:32 - Clickhouse configs 4:05 - Create and Start Cotainers 4:16 - Database connection 5:14 - JDBC Sink Connector 6:33 - Query Clickhouse to view Data Stream