Challenge
Migration MSSQL/Azure → ClickHouse/Greenplum/S3
Solution
MSSQL/Azure → ClickHouse/Greenplum/S3 migration, dbt transformations
Project Phases
1
MSSQL/Azure architecture audit
2
Target architecture design
3
Data migration
4
dbt transformation implementation
5
Load testing
Results
BEFORE
MSSQL/Azure, limited scalability, high costs
AFTER
2x performance, 20% storage cost reduction
Technologies
ClickHouseS3GreenplumAirflow