Skip to content

DBT Test: Accepted Values Comtrade Exports Frequency Code A

DBT test name: accepted_values_comtrade_exports_frequency_code__A

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
        frequency_code as value_field,
        count(*) as n_records

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

)

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