Comtrade 2020

s3://trase-storage/world/trade/statistical_data/comtrade/COMTRADE_2020.csv

Dbt path: trase_production.main.comtrade_2020

Explore on Metabase: Full table; summary statistics

Containing yaml file link: trase/data_pipeline/models/world/trade/statistical_data/comtrade/_schema.yml

Model file link: trase/data_pipeline/models/world/trade/statistical_data/comtrade/comtrade_2020.py

Dbt test runs & lineage: Test results · Lineage

Full dbt_docs page: Open in dbt docs (includes lineage graph -at the bottom right-, tests, and downstream dependencies)

Tags: mock_model, comtrade, statistical_data, trade, world

---

comtrade_2020

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. The script is located at trase/data/world/trade/statistical_data/comtrade/COMTRADE_20XX.py [permalink]. It was last run by Harry Biddle.

---

Details

ColumnsDepends OnModel code

Column	Type	Description

Models / Seeds

• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part29
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part19
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part16
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part4
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part9
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part23
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part0
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part1
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part17
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part21
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part5
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part11
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part2
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part13
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part12
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part10
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part20
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part7
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part14
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part27
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part28
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part18
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part3
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part26
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part6
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part25
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part15
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part22
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part24
• source.trase_duckdb.trase-storage-raw.comtrade_2020_retrieved_2023-11-08_part8

Sources

• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part29']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part19']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part16']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part4']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part9']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part23']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part0']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part1']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part17']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part21']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part5']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part11']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part2']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part13']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part12']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part10']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part20']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part7']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part14']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part27']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part28']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part18']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part3']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part26']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part6']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part25']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part15']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part22']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part24']
• ['trase-storage-raw', 'comtrade_2020_retrieved_2023-11-08_part8']

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part29")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part19")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part16")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part4")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part9")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part23")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part0")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part1")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part17")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part21")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part5")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part11")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part2")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part13")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part12")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part10")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part20")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part7")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part14")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part27")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part28")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part18")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part3")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part26")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part6")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part25")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part15")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part22")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part24")
    dbt.source("trase-storage-raw", "comtrade_2020_retrieved_2023-11-08_part8")

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