dbt-expectations for data quality - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is dbt-expectations in the context of data quality?

dbt-expectations is a package for dbt that helps you write tests to check your data quality by defining expectations or rules your data should meet.

intermediate

How does dbt-expectations improve data quality checks compared to basic dbt tests?

dbt-expectations provides a rich set of reusable, parameterized tests that cover common data quality scenarios, making it easier and faster to write thorough tests.

beginner

What is an example of a dbt-expectations test you can use to check for null values in a column?

You can use expect_column_values_to_not_be_null to ensure a column has no null values, which helps catch missing data issues.

beginner

Why is it important to use dbt-expectations tests in your data pipeline?

Using dbt-expectations tests helps catch data problems early, ensures data reliability, and builds trust in your data for decision-making.

beginner

How do you add dbt-expectations to your dbt project?

You add dbt-expectations by installing it as a package in your packages.yml file and then running dbt deps to download it.

What does the dbt-expectations test expect_column_values_to_be_unique check?

A That values in a column are within a range

B That a column has no null values

C That values in a column match a regex pattern

D That all values in a column are unique

This test ensures there are no duplicate values in the specified column.

Which file do you modify to add dbt-expectations as a dependency?

A dbt_project.yml

B packages.yml

C profiles.yml

D schema.yml

The packages.yml file is used to list external dbt packages like dbt-expectations.

What is the main benefit of using dbt-expectations tests over writing custom SQL tests?

A They are reusable and easier to maintain

B They require no configuration

C They run faster

D They automatically fix data issues

dbt-expectations provides reusable tests that save time and reduce errors compared to writing custom SQL tests.

Which dbt-expectations test would you use to check if values in a column fall within a specific set?

A expect_column_values_to_not_be_null

B expect_column_values_to_be_unique

C expect_column_values_to_be_in_set

D expect_column_values_to_match_regex

This test verifies that all values in a column are part of a predefined set.

After adding dbt-expectations to packages.yml, what command do you run to install it?

A dbt deps

B dbt test

C dbt compile

D dbt run

The command dbt deps downloads and installs packages listed in packages.yml.

Explain how dbt-expectations helps maintain data quality in a data project.

Think about how automated checks help in real life to avoid mistakes.

Describe the steps to add and use dbt-expectations in your dbt workflow.

Focus on setup and usage in your project.