GCP Analytics Platform with ClickHouse Reverse ETL

Client: Growth-stage SaaS company

A GCP analytics platform that combines sources in BigQuery with Airflow, tuned ClickHouse tables and reverse ETL back into the product.

The Challenge

Operational databases, APIs and marketing platforms were not connected, and user-level insights never made it back into the product.

Our Solution

Combined the sources in BigQuery with Airflow on Cloud Composer, designed ClickHouse tables for fast user-level processing, and built reverse ETL to send results back to downstream applications.

Outcomes

One BigQuery source for reporting and BI

Tuned ClickHouse tables and queries

User-level data sent back to the apps that need it

Technologies

BigQueryCloud ComposerAirflowClickHouse

Related case studies

Multi-Tenant E-Commerce Analytics

E-commerce analytics provider

LLM Supplier Entity-Matching Platform on GCP

Supplier-data integration partner

Config-Driven GCP Data Platform for Music Streaming

Music streaming platform

Have a Similar Project?

Tell us about your data or AI challenge and we'll show you how we would approach it.

Start a Project All Case Studies