Our data engineer insists in lowercasing everything and removing some other formatting like new lines on free text fields.
They say it’s “better for elastic search”.
To me that makes no sense and loses information that can’t be added back. But I couldn’t really convince them otherwise. So far no real problem has come out of it but it makes for a worse experience for the user. Like company names that are acronyms show up as all lowercase. (ibm, llc, etc.) or free text fields that we miss when the user wrote in caps or added paragraphs.
What are your thoughts on this?
Disclaimer, I’m not a data engineer. Just a PM from a data related product.
It is fine if your database has _A tables (also called journal or audit tables) as the previous values would be stored in the _A table entries in case you ever desired to get that data back.
But if your database is missing such good practices, tell them to just use lower() or upper() and leave your data alone