Data Build Tool Challenge - Data Testing

Lab Steps

lock
Data Build Tool Challenge - Basics
lock
Data Build Tool Challenge - Data Modeling
lock
Data Build Tool Challenge - Data Testing
Need help? Contact our support team

Here you can find the instructions for this specific Lab Step.

If you are ready for a real environment experience please start the Lab. Keep in mind that you'll need to start from the first step.

In this step, you will complete tasks relevant to data testing with dbt. Continue to the Validation Steps tab to perform these tasks.

Validation checks
2Checks
Defining a Schema File for Mart Models

As one of the last things you want to make in the sample project is to define a schema file where you can put the definition of models you have built.

Your manager is most interested in doing this operation for mart models. You are required to create a marts.yml file in the marts folder, that contains the column definitions of the two mart models you have previously created: f_orders_more_two_products and d_usa_employees.

Notes

  • Add all the columns you have defined in the two mart models
Data build tool (dbt)
Adding dbt Tests to Mart Models

As per the last operation to perform before showing the project to your manager, you have to add dbt native tests to the mart models definition you previously defined.

Add at least one test for each of the following categories:

  • not_null
  • unique
  • relationships

Notes

  • The tests need to be added in the marts.yml file you previously defined
Data build tool (dbt)