DBT Exposure: Brazil soy inputs: Bills of Lading / MDIC crosswalk

DBT exposure name: brazil_soy_qa_inputs_bol_mdic_crosswalk

Type: notebook

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

Owner: harry

---

Description

Checks the two custom fields — mdic_bol_region_of_destination and mdic_bol_port_group — that let the Brazil Bill-of-Lading and MDIC/SECEX datasets be joined, and quantifies how well the two sources agree on soybean export volume once matched on them. A check of the model's inputs, not of its output.

---

Details

Depends OnDBT details

Models

• brazil_bol_2023_gold
• brazil_mdic_port_2023

Sources

• country_iso_codes_source

• Dbt path: trase_duckdb.brazil_soy_qa_inputs_bol_mdic_crosswalk

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

• Original dbt_docs

• Tags: bol, brazil, mdic, qa, soy