By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

AWS Glue two date comparison data quality

0

Hello! I am new to AWS Glue and I starting to create data monitoring rules in AWS Glue. I have tried multiple options with CustomSQL but can not seem to find the solution. My problem: I want to check if date_from and date_to is logical sequence and that date_to is before date_to. Thank you in advance.

Topics
AnalyticsDatabase
Tags
AnalyticsDatabaseAWS GlueExtract Transform & Load Data
Language
English
kristalo
asked 13 days ago89 views
1 Answer
0

If all the data you need are columns in the same row, then you can just compare them (<), you could add a "Derived Column" and the value could be an expression that compares other columns with AND/OR condition if you need to

profile pictureAWS
EXPERT
Gonzalo Herreros
answered 13 days ago
profile pictureAWS
EXPERT
ben-from-aws
reviewed 13 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content