DBT: Comtrade 2021

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

DBT model name: comtrade_2021

Explore on Metabase: Full table; summary statistics

DBT details

Lineage
Test results
Dbt path: trase_production.main.comtrade_2021
Containing yaml link: trase/data_pipeline/models/world/trade/statistical_data/comtrade/_schema.yml
Model file: trase/data_pipeline/models/world/trade/statistical_data/comtrade/comtrade_2021.py
Original dbt_docs
Tags: mock_model, comtrade, statistical_data, trade, world

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"]})