This comprehensive 2-hour (recorded) workshop is designed to guide you through the essential steps and considerations for a successful BigQuery to ClickHouse migration. This workshop will kick off with an introduction to the key reasons why migrating from BigQuery to ClickHouse can significantly enhance your data processing capabilities. We will delve into the main conceptual differences between the two, covering crucial aspects such as primary keys, datasets, and quotas.

In the second module, we will explore the initial steps of the migration process. You will learn how to understand your dataset, map BigQuery data types to ClickHouse equivalents, and define primary keys in ClickHouse. We will also cover the process of loading data into ClickHouse, ensuring a smooth transition. The final module will focus on query acceleration techniques in ClickHouse, emphasizing materialized views, partitions, and other advanced techniques to optimize performance and scalability. This workshop is perfect for database administrators, data engineers, and developers looking to leverage ClickHouse’s powerful analytical capabilities. Register now to secure your spot!

The material is presented in modules and will include:

Module 1: Introduction

• Why migrate from BigQuery to ClickHouse?
• Main conceptual differences
  • Primary keys
  • Datasets
  • Quotas

Module 2: Schema Design

• Understand the Dataset
• ClickHouse Data Types
• ClickHouse Primary Keys
• Load Data

Module 3: Query Acceleration Techniques

• Partitions
• Materialized Views
• Other Techniques

Hosted by Pablo Musa (Principal Instructor) and Rich Raposa (Director, Global Learning)