The table metadata is a great feature to know the content of a table at a glance.
But with the data catalog, I’d like to locate some specificities about columns contents.
- is uppercase : how many values are fully uppercase
- is lowercase : how many values are fully lowercase
- has Arobase : how many values contains at least one @
- max dot : the MAX num of . in a value
- max comma
- max semi colon
- max quote
- max double quote
- max dash
- max slash
- max foward slash
- max space
- has non-ASCII
and the option “select all” in the table metadata transformation