Skip to main content
Skip to main content
Edit this page

BigQuery

This section covers everything you need to migrate from BigQuery to ClickHouse Cloud. Start with the overview to see how the two systems compare, then pick a migration path — either ClickPipes for managed change data capture, or GCS bulk-load for a one-shot export and import. Both walk-throughs use the Stack Overflow dataset as a worked example, and the best practices guide covers schema design and performance tuning.

PageDescription
OverviewAn overview of the similarities and differences between BigQuery and ClickHouse Cloud, covering resource hierarchy, data types, query features, and more.
Example BigQuery projectHow to set up the Stack Overflow example dataset in a BigQuery project to follow along with the migration guides.
Migrate using ClickPipesA step-by-step guide to migrating the Stack Overflow dataset from BigQuery to ClickHouse Cloud using ClickPipes, the managed CDC solution.
Migrate using GCS bulk-loadA step-by-step guide to migrating the Stack Overflow dataset from BigQuery to ClickHouse Cloud by bulk-loading from a Google Cloud Storage bucket.
Best practicesRecommended best practices to follow when migrating from BigQuery to ClickHouse Cloud.