TGViewer
Data Engineers Data Engineers @sql_engineer · 11.2K subscribers
Post #444 4.26K
What fundamental axioms and unchangeable principles exist in data engineering and data modeling?

Consider Euclidean geometry as an example. It's an axiomatic system, built on universal "true statements" that define the entire field. For instance, "a line can be drawn between any two points" or "all right angles are equal." From these basic axioms, all other geometric principles can be derived.

So, what are the axioms of data engineering and data modeling?

I asked ChatGPT about that and it gave this list:
▪️ Data exists in multiple forms and formats
▪️ Data can and should be transformed to serve the needs
▪️ Data should be trustworthy
▪️ Data systems should be efficient and scalable

Classic ChatGPT, pretty standard, pretty boring 🥱. Yes, these are universal and fundamental rules, but what can we learn from them?

Here is what I'd call axioms for myself:
🔹 Every table should have a primary key which is unique and not empty (dbt tests for life 🙂)
🔹 Every column should have strong types and constraints (storing data as STRING or JSON is ouch)
🔹 Data pipelines should be idempotent (I don't want to deal with duplicates and inconsistencies)
🔹 Every data transformation has to be defined in code (otherwise what are we doing here)
  • 👍 4
  • ❤ 1
More from @sql_engineer
  1. Aug 29, 2026Example: Source Database → CDC → Only Changed Records → Data Platform CDC is especially us…
  2. Aug 29, 2026🚀 Data Engineering Fundamentals – Part 7 📥 Data Ingestion: How Data Enters a Data Platfo…
  3. Aug 18, 2026🚀 Data Engineering Fundamentals – Part 6 📌 ETL vs ELT: How Data Moves from Source to Des…
  4. Aug 11, 2026📊 The 90-Minutes Business Analytics Masterclass Learn how to transform raw data into powe…
  5. Aug 8, 2026Data Warehouse Stores: Cleaned sales data Customer KPIs Revenue reports Historical busines…
  6. Aug 8, 2026🚀 Data Engineering Fundamentals – Part 4 📌 Databases vs Data Warehouses vs Data Lakes vs…
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook →Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 →