QuestionQ24
VerifiedData Ingestion and TransformationA company runs AWS Glue ETL pipelines to process data and uses Amazon Athena to analyze data in an Amazon S3 bucket.
To gain a better understanding of shipping timelines, the company decides to collect and store shipping and delivery dates alongside order data. The company adds a data quality check to confirm that the shipping date is greater than the order date and that the delivery date is greater than the shipping date. Orders that do not pass the quality check must be stored in a second S3 bucket.
Which solution will meet these requirements in the MOST cost-effective way?
Community Discussion