Задача
Миграция MSSQL/Azure → ClickHouse/Greenplum/S3
Решение
MSSQL/Azure → ClickHouse/Greenplum/S3 migration, dbt transformations
Этапы проекта
1
MSSQL/Azure architecture audit
2
Target architecture design
3
Data migration
4
dbt transformation implementation
5
Load testing
Результаты
ДО
MSSQL/Azure, limited scalability, high costs
ПОСЛЕ
2x performance, 20% storage cost reduction
Технологии
ClickHouseS3GreenplumAirflow