Testing Strategy
Unit Testing
Test connectivity to source (CRM, Billing, Kafka).
Validate sample SQL extraction queries with small date ranges.
Test ClickHouse batch insert with dummy data.
Verify error handling by injecting bad records.
Integration Testing
Run end-to-end ingestion from one telecom source → Raw → ABDR → Datamart.
Validate data accuracy (source vs. ClickHouse row counts).
Test partitioning & indexing with range queries.
Performance Testing
Test with various data volumes
Monitor execution time and memory usage
Validate concurrent execution scenarios
Last updated