You are supporting a data pipeline that pulls records from an external API into a warehouse for reporting and downstream analytics. The source changes field names, adds nested objects, and sometimes returns partial or malformed payloads, which causes broken loads and missing metrics. The team needs a clear way to keep data flowing while preserving traceability and backfill options.
What would you do if a customer’s data source has unstable APIs or frequent schema changes?
