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
preguntada hace 7 meses279 visualizaciones
1 Respuesta
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
respondido hace 7 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas