Testing for Table-Specific Data Issues

How to use singular tests in dbt to test tables at the source

Trying to make sense of database tables that have been around since the start of a company is a daunting task. Often times these are tables created without scale in mind, engineers just trying to put together a scrappy solution so the business can get off its feet.

But, years later, when we realize we have all this data that we can barely make sense of,…