Table Metadata features

Greetings,

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

Thank you

Regards

It sounds like we should add pre-defined custom expressions to the Table Metadata summary. That’s an interesting idea.

1 Like