dbt Defer Explained: How to Use --defer with a Practical Example
Learn how dbt --defer works with a practical dim_student example using --state, a production manifest, and upstream model references.
Data Engineering
131 posts
dbt Incremental Models Explained with a Practical Example
Learn dbt incremental models with a practical enrollment_cleaned example using materialized incremental, unique_key, is_incremental(), updated_at, and data tests.
How to Build Fact and Dimension Tables in dbt
Learn how to build business-ready fact and dimension tables in dbt using a simple Gold layer example with dim_course, dim_student, and fact_enrollment.
Why Codex Is a Productivity Booster for Data Engineers
Learn why Codex can make Data Engineers more productive by helping with dbt YAML, column descriptions, SQL reviews, debugging, boilerplate, and project conventions.
How to Use Codex to Create dbt Models
Learn how to use Codex to create a dbt Gold model from existing Silver models with clear prompts, dbt ref(), YAML tests, and a practical review workflow.
Understanding _dlt_id and _dlt_parent_id in dlt
Learn what _dlt_id and _dlt_parent_id mean in dlt, why they appear in normalized tables, and how to use them in SQL joins.
How dlt Loads Nested JSON into Tables in DuckDB
Learn how dlt normalizes nested JSON into parent and child tables in DuckDB using a simple students and courses example.
When to Use replace, append, or merge in a dlt Pipeline
Learn when to use replace, append, or merge in a dlt pipeline with practical DuckDB examples and beginner-friendly explanations.
How to Load JSON Data into DuckDB using dlt
Learn how to load a local JSON file into DuckDB with dlt, inspect the result with SQL, and understand a simple data pipeline pattern.