Skip to content

DBT Test: Accepted Values Comtrade Exports Partner2 Code 0

DBT test name: accepted_values_comtrade_exports_partner2_code__0

DBT details


Description

No description


Details

Models

Macros

  • test_accepted_values
  • get_where_subquery
{{ test_accepted_values(**_dbt_generic_test_kwargs) }}
with all_values as (

    select
        partner2_code as value_field,
        count(*) as n_records

    from "trase_production"."main"."comtrade_exports"
    group by partner2_code

)

select *
from all_values
where value_field not in (
    '0'
)