All work
12Data Engineering

Database Validation Tool

Data-validation tool from a real AWS Athena → Alibaba MaxCompute migration — detects missing IDs and value discrepancies across sources.

Architecture

Cross-database validation: fetches both sides in ID chunks, detects missing IDs and value discrepancies, and writes detailed reports.

Source DBsAthena · MaxCompute · Oracle · PG · MySQL · CH
Concurrent FetchChunked by ID
Validation EngineMissing IDs + discrepancies
CSV ReportsTimestamped output

Databases

AWS AthenaAlibaba MaxComputeOraclePostgreSQLMySQLClickHouse

Built with

Pythonpandas

Overview

A data-validation tool built during a real production migration from AWS Athena to Alibaba MaxCompute. It verifies that data landed correctly after migration.

It detects missing IDs and value discrepancies across sources, giving confidence that the migrated data matches the original. Beyond the migration use case, it also supports Oracle and PostgreSQL.

Highlights

  • Built for a real AWS Athena → Alibaba MaxCompute migration
  • Detects missing IDs and value-level discrepancies across sources
  • Extensible to Oracle and PostgreSQL

Role

Data Engineer — built the validation tooling

Context

Real production cloud migration (AWS ↔ Alibaba)

Tech stack

AWS AthenaAlibaba MaxComputeOraclePostgreSQLPython