DBT Exposure: Brazil soy v2.7.0: agreement with SECEX customs data

DBT exposure name: brazil_soy_qa_model_v2_7_vs_secex

Type: notebook

URL: https://github.com/sei-international/TRASE/blob/master/trase/models/brazil/soy_2023_2024_v27/qa/model_v2_7_vs_secex.qmd

Owner: harry

---

Description

Compares the v2.7.0 export output against the MDIC/SECEX port-level customs dataset — the authoritative independent benchmark — on product, state of origin and destination region, and repeats the comparison back through v2.6.0 and v2.6.1 for 2016-2025.

---

Details

Depends OnDBT details

Models

• sei_pcs_brazil_soy_by_year_tmp_1000
• seipcs_brazil_soy_2016
• seipcs_brazil_soy_2017
• m2_6_0_seipcs_brazil_soy_2019
• m2_6_0_seipcs_brazil_soy_2020
• m2_6_1_seipcs_brazil_soy_2021
• m2_6_1_seipcs_brazil_soy_2022
• brazil_mdic_port_2016
• brazil_mdic_port_2017
• brazil_mdic_port_2019
• brazil_mdic_port_2020
• brazil_mdic_port_2021
• brazil_mdic_port_2022
• brazil_mdic_port_2023
• brazil_mdic_port_2024
• brazil_mdic_port_2025
• crushing_facilities_2003_2024
• soy_production_ibge_2003_2023_multilevel

Sources

• br_states_wgs84_2023

• Dbt path: trase_duckdb.brazil_soy_qa_model_v2_7_vs_secex

• Exposure yml: trase/data_pipeline/models/brazil/soy/_exposures_brazil_soy_v2_7_0_qa.yml

• Original dbt_docs

• Tags: brazil, brazil_soy_2022_2025_update, mdic, qa, secex, sei_pcs, soy