Skip to content

Latest commit

 

History

History
21 lines (14 loc) · 1.68 KB

week3.md

File metadata and controls

21 lines (14 loc) · 1.68 KB

Task 1: Identify a few redundant tests that can be removed

  • I identified that the staging models with one to one relationships with the source tables have redundant tests, since the tests on columns are already performed on the source tables. Commit

Task 2: Write a custom generic test to replace a redundant singular test

  • Created the generic test here.
  • Used the test in the .yml file here.
Screenshot 2024-09-13 at 8 59 21 AM

Task 3: Write a unit test to verify the logic of a transformation

  • Created the unit test here
  • When I changed the expected value to 50 , here is the result of the dbt build command.
Screenshot 2024-09-13 at 9 21 58 AM

Task 4: Unit test to confirm correct mrr calculation

  • Created the unit test here
  • Here is an example when the test failed,
Screenshot 2024-09-13 at 10 30 19 AM