Comtrade 2021

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

Dbt path: trase_production.main.comtrade_2021

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_2021.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_2021

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_2021_retrieved_2023-07-28_part25
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part3
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part5
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part22
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part17
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part2
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part11
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part1
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part29
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part23
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part20
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part28
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part24
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part19
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part13
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part16
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part6
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part10
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part4
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part0
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part21
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part8
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part12
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part18
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part15
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part14
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part27
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part9
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part7
• source.trase_duckdb.trase-storage-raw.comtrade_2021_retrieved_2023-07-28_part26

Sources

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

No called script or script source not found.

import pandas as pd


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

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