DBT Exposure: Brazil soy v2.7: comparison with SECEX export data

DBT exposure name: brazil_soy_v27_comparison_to_secex_exports

Type: notebook

URL: https://github.com/sei-international/TRASE/blob/master/trase/products/analysis/notebooks/qa/brazil_soy_2023_24/comparison_to_secex_exports.qmd

Owner: harry

---

Description

Compares the final Brazil soy v2.7 model export output (bill-of-lading granularity, supply-shed solution applied) against the MDIC/SECEX port-level export dataset, and repeats the comparison back through the v2.6.0/v2.6.1 model versions for 2016-2024.

---

Details

Depends OnDBT details

Models

• sei_pcs_brazil_soy_2023_tmp_1000
• sei_pcs_brazil_soy_2024_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
• crushing_facilities_2003_2024
• soy_production_ibge_2003_2023_multilevel

• Dbt path: trase_duckdb.brazil_soy_v27_comparison_to_secex_exports

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

• Original dbt_docs

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