Data Quality statement or SQL query for empty columns

0

Hello, Is there a DQ rule that can identify empty or null columns? Or is there an sql query that can identify empty columns?

thanks.

neal_li
질문됨 7달 전279회 조회
1개 답변
0

Hello

According to the document below you could use ColumnLength to check if a column is not empty by checking if col length is greater than 0. Eg: ColumnLength "Postal_Code" > 0 https://docs.aws.amazon.com/glue/latest/dg/dqdl.html#dqdl-rule-types-ColumnLength

For not null you could use a custom sql as the example below: CustomSql "select Name from primary where Age IS NOT NULL" https://docs.aws.amazon.com/glue/latest/dg/dqdl.html#dqdl-rule-types-CustomSql

AWS
답변함 7달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인