dbt Series #5: Get start with Data ConstraintsA practical guide to defining, enforcing, and validating data integrity rules in your dbt models Introduction If you're coming to dbt from a SQL background, you're probably familiar with constraints aJul 31 · 9 min readajay990.hashnode.dev
dbt Series #4: Data Contracts – Defining What Your Data Should Look LikeIf you've worked with SQL long enough, you've probably experienced this frustration: you build a query that depends on specific columns existing in a table, with specific data types, only to have someJul 30 · 6 min readajay990.hashnode.dev
dbt Series #3: Singular Data TestsIn the first two posts of this series, we built dbt models and learned how to structure our data pipelines. But here's a question: How do we know our data is right? That's where data tests come in. ToJul 29 · 6 min readajay990.hashnode.dev
dbt Series #2 Understanding dbt Tests: A Practical Walkthrough with LeetCode 175Data quality doesn't happen by accident — it's tested for. In dbt, tests are how you turn assumptions about your data ("this column should never be null", "this ID should be unique") into automated chJul 28 · 5 min readajay990.hashnode.dev
dbt Series #1 Building and Testing Simple Filter Models in dbt(unit test)When you're learning dbt, it helps to start with something dead simple — filtering a table into two halves. That's exactly what this little project does: take a base model called one (just a list of iJul 27 · 3 min readajay990.hashnode.dev
