Skip to content

DBT: Brazil Bol 2025 Gold

File location: s3://trase-storage/brazil/trade/bol/2025/gold/brazil_bol_2025_gold.parquet

DBT model name: brazil_bol_2025_gold

Explore on Metabase: Full table; summary statistics

Explore dependencies/lineage: link

Description

Based on the cleaned version of Brazil BOL 2025 (brazil_bol_2025_silver), only including curated fields. Find where the fields come from and how they were cleaned in the fields documentation, and all the available source fields in silver version, and the vendor field glossary in google spreadsheets.

Details

Column Type Description
commodity VARCHAR
country_of_destination_economic_bloc VARCHAR
country_of_destination_label VARCHAR
country_of_destination_name VARCHAR
country_of_destination_trase_id VARCHAR
date DATE
year INTEGER
month INTEGER
exporter_cnpj VARCHAR
exporter_country_label VARCHAR
exporter_group VARCHAR
exporter_label VARCHAR
exporter_municipality_label VARCHAR
exporter_municipality_name VARCHAR
exporter_municipality_trase_id VARCHAR
exporter_name VARCHAR
exporter_node_id BIGINT
exporter_state_label VARCHAR
exporter_state_name VARCHAR
exporter_state_trase_id VARCHAR
exporter_trase_id VARCHAR
exporter_type VARCHAR
fob DOUBLE
fob_adjustment_type VARCHAR
fob_original DOUBLE
hs4 VARCHAR
hs5 VARCHAR
hs6 VARCHAR
hs6_description VARCHAR
hs8 VARCHAR
importer_group VARCHAR
importer_label VARCHAR
importer_name VARCHAR
importer_node_id BIGINT
net_weight_kg DOUBLE
net_weight_tonnes DOUBLE
port_of_export_label VARCHAR
port_of_export_name VARCHAR
port_of_import_country_label VARCHAR
port_of_import_country_name VARCHAR
port_of_import_label VARCHAR
port_of_import_name VARCHAR
mdic_bol_region_of_destination VARCHAR Destination country (country_of_destination_trase_id) mapped to a broad world region, used only to join the BOL dataset with MDIC/SECEX exports. ERROR - UNMAPPED would indicate a country missing from the shared crosswalk.
mdic_bol_port_group VARCHAR Export port (port_of_export_name) mapped to a named port group/complex, used only to join the BOL dataset with MDIC/SECEX exports. ERROR - UNMAPPED would indicate a port missing from the shared crosswalk.

Review full report including sample errors records if they exist (link)

Test column Test name Failing rows Last test run Last status Query in Metabase
mdic_bol_port_group dbt_expectations_expect_column_unique_value_count_to_be_between_brazil_bol_2025_gold_mdic_bol_port_group__40__1 — 2026-07-07 15:09 pass 🔍 run query
mdic_bol_port_group dbt_utils_expression_is_true_brazil_bol_2025_gold_mdic_bol_port_group___ERROR_UNMAPPED_ — 2026-07-07 15:10 pass 🔍 run query
mdic_bol_port_group not_null_brazil_bol_2025_gold_mdic_bol_port_group — 2026-07-07 15:12 pass 🔍 run query
mdic_bol_region_of_destination dbt_expectations_expect_column_unique_value_count_to_be_between_brazil_bol_2025_gold_mdic_bol_region_of_destination__10__1 — 2026-07-07 15:09 pass 🔍 run query
mdic_bol_region_of_destination dbt_utils_expression_is_true_brazil_bol_2025_gold_mdic_bol_region_of_destination___ERROR_UNMAPPED_ — 2026-07-07 15:10 pass 🔍 run query
mdic_bol_region_of_destination not_null_brazil_bol_2025_gold_mdic_bol_region_of_destination — 2026-07-07 15:12 pass 🔍 run query

Models

Models

No called script or script source not found.

"""Brazil BOL 2025 Gold

Curated subset of `brazil_bol_2025_silver` plus the two MDIC-matching columns. The column list
and mapping logic are shared across years in `trase/data/brazil/trade/bol/bol_gold.py`.
"""

from trase.data.brazil.trade.bol.bol_gold import build_gold


def model(dbt, cursor):
    dbt.config(materialized="external")
    return build_gold(dbt.ref("brazil_bol_2025_silver").pl().lazy())