DBT Exposure: Brazil soy v2.7.0 decision: Sao Paulo office logistics hubs

DBT exposure name: brazil_soy_qa_decision_sao_paulo_office_hubs

Type: notebook

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

Owner: harry

---

Description

Investigates why Sao Paulo, which has almost no soy storage and no crushing, is the largest logistics hub in the v2.7.0 output, tracing the volume to head offices whose CNPJ registration carries a storage or farm CNAE, and sizes the exception that was added in response. Every input is pinned to an S3 version ID, so a re-render reproduces the August 2026 analysis rather than reading the current model output.

---

Details

Depends OnDBT details

Models

• sei_pcs_brazil_soy_by_year_tmp_1000
• soy_cnpj_by_year
• silos_consolidated_capacity_brazil_2024_2
• crushing_facilities_2003_2024

Sources

• municipality

• Dbt path: trase_duckdb.brazil_soy_qa_decision_sao_paulo_office_hubs

• 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, qa, sei_pcs, soy