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 😁
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 😁
Agreed. I still struggle with where it fits in the data value chain, upstream with data engineering or downstream with analytics engineering.
Insightful