Dbt, Data Quality, Data Testing, Data Analytics, Data Governance.
not_null_proportion from (select * from stg_customers where country not in ('US', 'Canada')) dbt_subquery ), validation_errors as ( select not_null_proportion from validation where not_null_proportion < 0.99 or not_null_proportion > 1 ) select * from validation_errors By setting this proportional