AWS Glue two date comparison data quality

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.

主題

分析資料庫

標籤

分析資料庫 AWS Glue 提取轉換與載入資料

語言

English

kristalo

已提問 1 個月前檢視次數 146 次

1 個回答

最新
最多得票
最多評論

這些答案是否有幫助？支持正確答案，以幫助社區從您的知識中受益。

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

專家

Gonzalo Herreros

已回答 1 個月前

專家

ben-from-aws

已審閱 1 個月前

AWS Glue two date comparison data quality

相關內容