ASajay singh rathoreinajay990.hashnode.dev·Jul 31 · 9 min readdbt 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 a00
ASajay singh rathoreinajay990.hashnode.dev·Jul 30 · 6 min readdbt 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 some00
ASajay singh rathoreinajay990.hashnode.dev·Jul 29 · 6 min readdbt 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. To00
ASajay singh rathoreinajay990.hashnode.dev·Jul 28 · 5 min readdbt 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 ch00
ASajay singh rathoreinajay990.hashnode.dev·Jul 27 · 3 min readdbt 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 i00
