Automated ETL Audit Trail and Data Lineage Register

This workbook documents ETL processes with lineage mapping and automated audit trails. Track source files, transform scripts, last run timestamps, row counts, and data owners. Compute differences in row counts and data quality metrics and flag anomalies. Maintain a change log that records schema changes, field mappings and transformation versions to support debugging and compliance. Export lineage tables to support data governance programs and to onboard new analysts quickly. For production systems, integrate with your orchestration/metadata tools; this workbook serves as an operational artifact for smaller teams.