Comtrade 2022

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

Dbt path: trase_production.main.comtrade_2022

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

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

Sources

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

No called script or script source not found.

import pandas as pd


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

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