end to end ingestion tests