Why Analytics Leaders Are Embracing Modern Data Platforms: A Look at dbt & Snowflake

by Kristi Smith Are you an analytics leader thinking about moving to a more modern data platform, but not sure where to start? Makes sense; there are a lot of options out there. Red Pill Analytics understands that analytics leaders are facing a tough challenge: how to transform raw data into insights while managing complex […]

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 data 2. Validation — Relationship and data validations. Transformations into facts and dims 3. Reporting — joining facts and dims to meet presentation requirements 4. Business Application — presentation layer. Views, with security where needed, of the reporting objects When we added relationship tests between project.