>>106833273
what is it about "data warehouses" that seems to attract the absolute bottom of the barrel design and management practices?
like the one i have to interact with:
>tables are named after jira epics
>each jira epic can have dozens of tables, each repeating some bit of data on the main table for that epic
>most table and column names are 50+ characters
>denormalized in the stupidest way imaginable, rife with data duplication like putting legal names and cost centers in the education table
>zero attempt at using the relational part of a relational database
>at least once a week, one or more of the tables we use will either be empty or have each row duplicated hundreds of times
>there are dev, qa, and prod environments, but they arent the same because they manually deploy changes and mess around with shit, causing some tables to be inaccessible to us in certain environments whenever they decide to add ssns to the schema for shits and giggles
oh and its aws athena too so there isnt a decent intellij plugin i can use to explore it within my ide