mdatool.

Loading usage...

Settings
Data Engineering

Bulk Sanitizer.

Transform messy source lists into standardized physical names. Automatically applies your enterprise abbreviations and naming conventions in seconds.

Mode

Enterprise Upper Snake Case

Source Column NamesLines: 4
Standardized Output
CUSTOMER_NAME
Customer name
CUSTOMER_IDENTIFIER
customer identifier
CUSTOMER_INDICATOR
customer indicator
PARTY_CODE
party code

Loading usage...

Character Cleaning

  • • Removes special characters (#, @, !, $)
  • • Handles multiple spaces and underscores
  • • Strips leading and trailing delimiters

Glossary Matching

  • • Matches tokens against Enterprise Abbreviations
  • • Suggests official acronyms (e.g., Account → ACCT)
  • • Preserves unknown terms for manual review

Physical Formatting

  • • Enforces Global UPPER_SNAKE_CASE
  • • Standardizes Date/ID suffixes
  • • Optimizes for DB object length limits