DBT: Brazil Mdic Disaggregated 2019

File location: s3://trase-storage/brazil/trade/mdic/disaggregated/brazil_mdic_disaggregated_2019.csv

DBT model name: brazil_mdic_disaggregated_2019

Explore on Metabase: Full table; summary statistics

DBT details

• Lineage

• Test results

• Dbt path: trase_production.main_brazil.brazil_mdic_disaggregated_2019

• Containing yaml link: trase/data_pipeline/models/brazil/trade/mdic/disaggregated/_schema_brazil_mdic_dissaggregated.yml

• Model file: trase/data_pipeline/models/brazil/trade/mdic/disaggregated/brazil_mdic_disaggregated_2019.py

• Calls script: trase/models/brazil/customs_2019

• Original dbt_docs

• Tags: mock_model, brazil, disaggregated, mdic, trade

---

Description

Brazil MDIC/SECOMEX Disaggregation

This dataset attempts to reconstruct the MDIC/SECOMEX trade export dataset to the level of information that was provided before 2018. To do so, it combines the post-2018 MDIC/SECOMEX trade export datasets with bills of lading.

This reconstruction is run as a model written in using the supply chain mapping tool: see trase/models/brazil/customs_2019/README.md.

History

It was last run by Nanxu Su for the update to the Brazil beef model to add the year 2020. Since we only needed the model output for beef, we filtered to beef commodity codes and wrote the file brazil_mdic_disaggregated_2020_beef.csv.

---

Details

ColumnsDepends OnModel code

Column	Type	Description

Models / Seeds

• model.trase_duckdb.brazil_mdic_port_2019
• model.trase_duckdb.empresas_cadastro_2019
• model.trase_duckdb.brazil_mdic_municipality_2019
• model.trase_duckdb.brazil_bol_2019

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.ref("brazil_mdic_port_2019")
    dbt.ref("empresas_cadastro_2019")
    dbt.ref("brazil_mdic_municipality_2019")
    dbt.ref("brazil_bol_2019")

    raise NotImplementedError()
    return pd.DataFrame({"hello": ["world"]})