dbt Archives - Red Pill Analytics

Clear the Clutter! Find and Drop Undead dbt-Created Tables

by Alyssa Kunau Photo by todd kent on Unsplash Clutter- What is it? Where did it come from? In this guide, I’ll show you how to find and drop undead DBT-created tables to clear clutter. By “db clutter” I mean unnecessary, unused objects living in your database. There’s gonna be some word clutter here. In this post I’m […]

Master dbt Testing: How to Avoid False Negatives when Testing Between Project Layers

We have a small project with four layers: 1. Raw — incoming raw data2. Validation —Relationship and data validations. Transformations into facts and dims3. Reporting — joining facts and dims to meet presentation requirements4. Business Application — presentation layer. Views, with security where needed, of the reporting objects When we added relationship tests between project

Master dbt Testing: How to Avoid False Negatives when Testing Between Project Layers Read More »

Business Intelligence, Data Engineering, dbt