Dbt, Data Quality, Data Testing, Data Analytics, Data Governance.
The compiled SQL query will then be: with validation as ( select sum(case when customer_city is null then 0 else 1 end) / cast(count(*) as numeric) as not_null_proportion from stg ), validation_errors as ( select not_null_proportion from validation where not_null_proportion < 0.99 or