DBT: Brazil Bol 2018

File location: s3://trase-storage/brazil/trade/bol/2018/BRAZIL_BOL_2018.csv

DBT model name: brazil_bol_2018

Explore on Metabase: Full table; summary statistics

Explore dependencies/lineage: link

---

Description

This model was auto-generated based off .yml 'lineage' files in S3. The DBT model just raises an error; the actual script that created the data lives elsewhere. It was last run by Harry Biddle.

---

Details

ColumnsData TestsReferenced ByDepends OnModel codeDBT details

Column	Type	Description
date	VARCHAR
exporter.label	VARCHAR
country_of_destination.label	VARCHAR
vol	VARCHAR
hs_description	VARCHAR
exporter.cnpj	VARCHAR
exporter.activity_portuguese	VARCHAR
importer.label	VARCHAR
vessel.label	VARCHAR
voyage_number	VARCHAR
hs	VARCHAR
port_of_origin.label	VARCHAR
port_of_arrival.label	VARCHAR
port_of_import.label	VARCHAR
world_region	VARCHAR
place_of_loading	VARCHAR
source	VARCHAR
hs4	VARCHAR
hs6	VARCHAR
hs8	VARCHAR
carrier_datamar.label	VARCHAR
description	VARCHAR
port_of_discharge	VARCHAR
importer.type	VARCHAR
port_of_maritime_origin.country	VARCHAR
port_of_maritime_destination	VARCHAR
port_of_maritime_origin	VARCHAR
carrier.label	VARCHAR
port_of_export.country	VARCHAR
exporter.type	VARCHAR
port_of_maritime_destination.country	VARCHAR
port_of_receipt.country	VARCHAR
port_of_destination	VARCHAR
port_of_receipt	VARCHAR
vessel.type	VARCHAR
port_of_discharge.country	VARCHAR
datamar_id	VARCHAR
port_of_export.name	VARCHAR
country_of_destination.name	VARCHAR
country_of_destination.trase_id	VARCHAR
exporter.state.trase_id	VARCHAR
exporter.municipality.trase_id	VARCHAR
exporter.state.name	VARCHAR
exporter.municipality.name	VARCHAR
hs5	VARCHAR
month	VARCHAR

No data tests defined 🧐

Models

• brazil_mdic_disaggregated_2018_beef_01
• brazil_mdic_disaggregated_2018_beef_02
• cd_disaggregated_beef_2018_02

Exposures

• qa_bol_2021_2023BR_BOL_COMTRADE_MDIC_BEEF (view exposure, view documentation)

Sources

• 7_11
• 5_07
• 10_09
• 1_09
• 2_02
• 0_03
• 11_11
• 10_03
• 7_09
• 10_07
• 6_02
• 3_06
• 4_08
• 7_07
• 1_04
• 0_12
• 13_11
• 4_10
• 5_11
• 9_04
• 2_07
• 4_11
• 7_01
• 9_07
• 4_05
• 9_11
• dataliner report_stockholm_exp br_2018 (version 1 from 5_10_2021) - live animals
• 1_03
• 1_06
• 4_12
• 7_05
• 1_11
• 7_10
• 5_01
• 3_04
• 1_10
• 4_09
• 9_08
• 6_03
• 3_02
• 9_09
• 6_07
• 5_09
• 0_07
• 7_08
• 2_10
• 5_02
• 8_01
• 8_11
• 0_09
• 1_01
• 11_08
• 4_07
• 6_06
• 2_05
• 3_12
• 3_01
• 5_03
• 7_03
• 3_05
• 7_04
• 2_06
• 2_04
• 3_03
• 9_12
• 5_10
• 4_01
• 10_11
• 3_08
• 1_02
• 3_10
• 8_04
• 9_05
• 12_11
• 8_05
• 4_06
• 11_10
• 4_03
• 5_04
• 6_10
• 4_02
• 5_08
• 8_02
• 6_04
• 2_03
• 3_07
• 9_10
• 0_01
• 0_05
• 6_08
• 10_08
• 5_06
• 8_10
• 4_04
• 10_10
• 6_09
• 8_07
• 11_07
• 8_12
• 2_01
• 8_06
• 0_11
• 1_07
• 10_12
• 2_08
• 0_10
• 7_06
• 8_09
• 2_09
• 7_02
• 0_02
• commodity_dict
• 6_12
• 0_06
• 7_12
• 8_03
• 3_09
• 6_05
• 8_08
• 9_03
• 1_12
• 1_05
• 3_11
• 5_12
• 0_04
• 6_01
• 5_05
• 6_11
• 0_08

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.source("trase-storage-raw", "7_11")
    dbt.source("trase-storage-raw", "5_07")
    dbt.source("trase-storage-raw", "10_09")
    dbt.source("trase-storage-raw", "1_09")
    dbt.source("trase-storage-raw", "2_02")
    dbt.source("trase-storage-raw", "0_03")
    dbt.source("trase-storage-raw", "11_11")
    dbt.source("trase-storage-raw", "10_03")
    dbt.source("trase-storage-raw", "7_09")
    dbt.source("trase-storage-raw", "10_07")
    dbt.source("trase-storage-raw", "6_02")
    dbt.source("trase-storage-raw", "3_06")
    dbt.source("trase-storage-raw", "4_08")
    dbt.source("trase-storage-raw", "7_07")
    dbt.source("trase-storage-raw", "1_04")
    dbt.source("trase-storage-raw", "0_12")
    dbt.source("trase-storage-raw", "13_11")
    dbt.source("trase-storage-raw", "4_10")
    dbt.source("trase-storage-raw", "5_11")
    dbt.source("trase-storage-raw", "9_04")
    dbt.source("trase-storage-raw", "2_07")
    dbt.source("trase-storage-raw", "4_11")
    dbt.source("trase-storage-raw", "7_01")
    dbt.source("trase-storage-raw", "9_07")
    dbt.source("trase-storage-raw", "4_05")
    dbt.source("trase-storage-raw", "9_11")
    dbt.source(
        "trase-storage-raw",
        "dataliner report_stockholm_exp br_2018 (version 1 from 5_10_2021) - live animals",
    )
    dbt.source("trase-storage-raw", "1_03")
    dbt.source("trase-storage-raw", "1_06")
    dbt.source("trase-storage-raw", "4_12")
    dbt.source("trase-storage-raw", "7_05")
    dbt.source("trase-storage-raw", "1_11")
    dbt.source("trase-storage-raw", "7_10")
    dbt.source("trase-storage-raw", "5_01")
    dbt.source("trase-storage-raw", "3_04")
    dbt.source("trase-storage-raw", "1_10")
    dbt.source("trase-storage-raw", "4_09")
    dbt.source("trase-storage-raw", "9_08")
    dbt.source("trase-storage-raw", "6_03")
    dbt.source("trase-storage-raw", "3_02")
    dbt.source("trase-storage-raw", "9_09")
    dbt.source("trase-storage-raw", "6_07")
    dbt.source("trase-storage-raw", "5_09")
    dbt.source("trase-storage-raw", "0_07")
    dbt.source("trase-storage-raw", "7_08")
    dbt.source("trase-storage-raw", "2_10")
    dbt.source("trase-storage-raw", "5_02")
    dbt.source("trase-storage-raw", "8_01")
    dbt.source("trase-storage-raw", "8_11")
    dbt.source("trase-storage-raw", "0_09")
    dbt.source("trase-storage-raw", "1_01")
    dbt.source("trase-storage-raw", "11_08")
    dbt.source("trase-storage-raw", "4_07")
    dbt.source("trase-storage-raw", "6_06")
    dbt.source("trase-storage-raw", "2_05")
    dbt.source("trase-storage-raw", "3_12")
    dbt.source("trase-storage-raw", "3_01")
    dbt.source("trase-storage-raw", "5_03")
    dbt.source("trase-storage-raw", "7_03")
    dbt.source("trase-storage-raw", "3_05")
    dbt.source("trase-storage-raw", "7_04")
    dbt.source("trase-storage-raw", "2_06")
    dbt.source("trase-storage-raw", "2_04")
    dbt.source("trase-storage-raw", "3_03")
    dbt.source("trase-storage-raw", "9_12")
    dbt.source("trase-storage-raw", "5_10")
    dbt.source("trase-storage-raw", "4_01")
    dbt.source("trase-storage-raw", "10_11")
    dbt.source("trase-storage-raw", "3_08")
    dbt.source("trase-storage-raw", "1_02")
    dbt.source("trase-storage-raw", "3_10")
    dbt.source("trase-storage-raw", "8_04")
    dbt.source("trase-storage-raw", "9_05")
    dbt.source("trase-storage-raw", "12_11")
    dbt.source("trase-storage-raw", "8_05")
    dbt.source("trase-storage-raw", "4_06")
    dbt.source("trase-storage-raw", "11_10")
    dbt.source("trase-storage-raw", "4_03")
    dbt.source("trase-storage-raw", "5_04")
    dbt.source("trase-storage-raw", "6_10")
    dbt.source("trase-storage-raw", "4_02")
    dbt.source("trase-storage-raw", "5_08")
    dbt.source("trase-storage-raw", "8_02")
    dbt.source("trase-storage-raw", "6_04")
    dbt.source("trase-storage-raw", "2_03")
    dbt.source("trase-storage-raw", "3_07")
    dbt.source("trase-storage-raw", "9_10")
    dbt.source("trase-storage-raw", "0_01")
    dbt.source("trase-storage-raw", "0_05")
    dbt.source("trase-storage-raw", "6_08")
    dbt.source("trase-storage-raw", "10_08")
    dbt.source("trase-storage-raw", "5_06")
    dbt.source("trase-storage-raw", "8_10")
    dbt.source("trase-storage-raw", "4_04")
    dbt.source("trase-storage-raw", "10_10")
    dbt.source("trase-storage-raw", "6_09")
    dbt.source("trase-storage-raw", "8_07")
    dbt.source("trase-storage-raw", "11_07")
    dbt.source("trase-storage-raw", "8_12")
    dbt.source("trase-storage-raw", "2_01")
    dbt.source("trase-storage-raw", "8_06")
    dbt.source("trase-storage-raw", "0_11")
    dbt.source("trase-storage-raw", "1_07")
    dbt.source("trase-storage-raw", "10_12")
    dbt.source("trase-storage-raw", "2_08")
    dbt.source("trase-storage-raw", "0_10")
    dbt.source("trase-storage-raw", "7_06")
    dbt.source("trase-storage-raw", "8_09")
    dbt.source("trase-storage-raw", "2_09")
    dbt.source("trase-storage-raw", "7_02")
    dbt.source("trase-storage-raw", "0_02")
    dbt.source("trase-storage-raw", "commodity_dict")
    dbt.source("trase-storage-raw", "6_12")
    dbt.source("trase-storage-raw", "0_06")
    dbt.source("trase-storage-raw", "7_12")
    dbt.source("trase-storage-raw", "8_03")
    dbt.source("trase-storage-raw", "3_09")
    dbt.source("trase-storage-raw", "6_05")
    dbt.source("trase-storage-raw", "8_08")
    dbt.source("trase-storage-raw", "9_03")
    dbt.source("trase-storage-raw", "1_12")
    dbt.source("trase-storage-raw", "1_05")
    dbt.source("trase-storage-raw", "3_11")
    dbt.source("trase-storage-raw", "5_12")
    dbt.source("trase-storage-raw", "0_04")
    dbt.source("trase-storage-raw", "6_01")
    dbt.source("trase-storage-raw", "5_05")
    dbt.source("trase-storage-raw", "6_11")
    dbt.source("trase-storage-raw", "0_08")

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

• Dbt path: memory.main.brazil_bol_2018

• Containing yaml link: trase/data_pipeline/models/brazil/trade/bol/2018/_schema.yml

• Model file: trase/data_pipeline/models/brazil/trade/bol/2018/brazil_bol_2018.py

• Original dbt_docs

• Tags: mock_model, 2018, bol, brazil, trade