Configuring dbt Model Access using Grants: A Practical Example
Learn how to configure dbt grants so data engineers can query all models, data analysts can query Gold models, and data scientists can query one specific model.
dbt Analytics Engineering Certification
Get prepared for the dbt Analytics Engineering Certification exam and become a certified dbt Analytics Engineer. Learn key concepts, best practices, and hands-on techniques to master dbt, Data Modeling, and Analytics. Start your journey to certification today!
39 posts
Understanding dbt State: How state:modified Works with a Practical Example
Learn how dbt state works with a practical state:modified example using a production manifest.json and a changed dim_student model.
dbt clone Explained: How to Use dbt clone with a Practical Example
Learn how dbt clone works with a practical dim_student example using production state artifacts and a development target schema.
How to Use dbt Snapshots with a Practical Example
Learn how to use dbt snapshots with a practical student example, the timestamp strategy, updated_at, and historical records.
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.
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.
dbt Snapshots Explained: Track Historical Changes in Your Data Warehouse
Learn what dbt snapshots are, why they matter, and how to track historical changes in your data warehouse with a beginner-friendly customer status example.
dbt Exposures Explained for Beginners: Connect Models to Dashboards, Reports, and ML Models
Learn what dbt exposures are, why they matter, and how to connect dbt models to dashboards, reports, notebooks, and machine learning workflows.