3 Comments

I’ve been finding that setting unique and not NULL tests on the expected primary keys  of the output of my queries has been really helpful (I use dbt to abstract the act of actually implementing the tests, but in theory you could do that by writing the SQL code to test it)

TDD should be a method available to analysts and data engineers, not just software engineers 😁

Expand full comment

Agreed. I still struggle with where it fits in the data value chain, upstream with data engineering or downstream with analytics engineering.

Expand full comment

Insightful

Expand full comment