Inclusive Data Architecture Choices
Many choices for your data platform aren’t exclusive.
This applies to Data Modeling
And Data Architecture.
Data Architecture Training material: “First, choose whether you want an Extract-Transform-Load (ETL) or an Extract-Load-Transform (ELT) data architecture”
Data Architect in the wild: “We currently have an ETLTLTTTL pattern but that might change next week”
ETL or ELT is not a single choice. It will likely be ETLLTL or ELTLTTL or some combination that no one has implemented yet.
Understand core frameworks for data platforms. Learn data modeling theory. Lean ETL/ELT patterns.
Then mix and match. Combine. Invert.
Implementing a pattern isn’t the aim.
Being invaluable to the business is.
I’m here,
Sawyer