Your question is Ingest JSON Daily Pipeline. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Design a data pipeline to ingest a JSON file into the data warehouse daily.
Describe a practical batch design using specific technologies such as Amazon S3, Apache Airflow, Python or Spark, and Snowflake. Explain file detection, schema validation, transformations, idempotent loading, retries, failure recovery, data quality checks, lineage, and operational monitoring. Include how you would handle malformed records, duplicate files, schema evolution, reruns, and historical backfills.