Warehouse-first content for schema design, review, and handoff
Practical articles for analytics engineers and warehouse teams — covering dbt, Snowflake, dimensional modeling, normalization, and visual schema design with real examples and mental models.
Latest articles
Each post is written to help teams design cleaner schemas, review changes earlier, and hand off warehouse work with less ambiguity — with code examples, diagrams, and mental models you can apply immediately.
How to model a star schema in dbt
Turn transactional source tables into a clean dbt star schema with clear grain, conformed dimensions, and reviewable marts.
Snowflake schema design best practices for analytics teams
Snowflake makes it easy to ship fast, but long-term clarity still depends on disciplined schema design, review, and documentation.
Dimensional modeling tutorial for analytics teams
A straightforward dimensional modeling workflow for analytics teams that need cleaner marts, better reviews, and fewer downstream surprises.
Database normalization: 1NF, 2NF, and 3NF explained with examples
Learn how to normalize a database step by step: eliminate repeating groups, remove partial dependencies, and cut transitive dependencies — with concrete SQL examples.
ERD fundamentals: how to design database schemas visually
Understand ERD basics — entities, attributes, relationships, and cardinality — and learn how to turn a visual diagram into deployable SQL.
Design schemas visually, deploy with confidence
SchemaStruct turns the concepts in these articles into a live workflow — visual ERD editor, DSL-backed review, SQL export, dbt integration, and data dictionary in one place.