Question 223
You are building an ELT solution in BigQuery by using Dataform. You need to perform uniqueness and null value checks on your final tables. What should you do to efficiently integrate these checks into your pipeline?
- A. Build BigQuery user-defined functions (UDFs).
- B. Create Dataplex data quality tasks.
- C. Build Dataform assertions into your code.
- D. Write a Spark-based stored procedure.
- Dataform provides a feature called "assertions," which are essentially SQL-based tests that you can define to verify the quality of your data.
- Assertions in Dataform are a built-in way to perform data quality checks, including checking for uniqueness and null values in your tables.
https://cloud.google.com/dataform/docs/assertions