DBT: Cd Brazil 2018

File location: s3://trase-storage/brazil/trade/cd/dashboard/out/CD_BRAZIL_2018.csv

DBT model name: cd_brazil_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 Nanxu Su.

---

Details

ColumnsData TestsReferenced ByDepends OnModel codeDBT details

Column	Type	Description

No data tests defined 🧐

Not referenced by any model or exposure.

Sources

• master_2015_65001_70000
• chicken_2018
• coffee_2015_2
• cotton_2018
• soy_2018
• brazil_cotton_2015_5001_10000
• master_2015_110001_115000
• master_2015_115001_120000
• master_2015_45001_50000
• pork_2018
• beef_2015_3
• master_2015_1_5000
• cd_8_2018
• cd_brazil_2017_75001_80000
• cd_3_2018
• master_2015_105001_110000
• cd_brazil_2017_85001_90000
• master_2015_120001_125000
• coffee_2015_3
• master_2015_40001_45000
• beef_2015_1
• master_2016_135001_140000
• master_2015_5001_10000
• master_2015_90001_95000
• master_2015_130001_135000
• master_2016_10001_15000
• cd_brazil_2017_70001_75000
• master_2016_30001_35000
• cd_brazil_2017_15001_20000
• cd_brazil_chicken_2017_2
• master_2016_130001_135000
• cd_brazil_coffee_2015
• master_2015_30001_35000
• cane_2018
• master_2015_95001_100000
• master_2015_70001_75000
• cd_brazil_2017_45001_50000
• master_2016_35001_40000
• beef_2017_2
• master_2015_15001_20000
• coffee_2016_3
• cd_brazil_2017_1_5000
• trasesei-49782-brazil2016cotton1_1524593044251
• cd_brazil_2017_90001_95000
• cd_brazil_2017_5001_10000
• cd_brazil_2017_10001_15000
• master_2015_20001_25000
• master_2016_105001_110000
• master_2016_110001_115000
• cd_brazil_beef_2016
• coffee_2016_2
• brazil_cotton_2015_1_5000
• cd_brazil_2017_60001_65000
• master_2016_140001_140056
• master_2016_75001_80000
• cd_4_2018
• beef_2016_2
• cd_6_2018
• cd_1_2018
• cd_5_2018
• beef_2018_2
• coffee_2017_1
• master_2015_85001_90000
• corn_2018
• beef_2018_1
• master_2016_100001_105000
• master_2016_115001_120000
• master_2016_80001_85000
• cd_brazil_2017_80001_85000
• master_2016_1_5000
• master_2016_5001_10000
• cd_brazil_coffee_2017
• cd_brazil_2017_95001_99554
• cd_brazil_chicken_2017
• master_2015_135001_139457
• master_2015_10001_15000
• cd_brazil_2017_20001_25000
• trasesei-49783-brazil2016cotton2_1524593193134
• master_2016_65001_70000
• master_2016_20001_25000
• master_2016_95001_100000
• cd_2_2018
• cd_brazil_2017_55001_60000
• beef_2017_4
• cd_brazil_beef_2017
• beef_2016_1
• cd_9_2018
• master_2016_45001_50000
• cd_7_2018
• master_2015_35001_40000
• master_2015_125001_130000
• master_2016_125001_130000
• cd_brazil_2017_35001_40000
• cd_brazil_2017_50001_55000
• timber_2018
• master_2015_75001_80000
• master_2015_100001_105000
• master_2016_55001_60000
• cd_brazil_2017_65001_70000
• brazil_cotton_2015_10001_11245
• master_2015_25001_30000
• master_2016_85001_90000
• cd_brazil_coffee_2016
• beef_2015_2
• coffee_2017_2
• coffee_2015_1
• coffee_2016_1
• cd_brazil_chicken_2017_1
• cd_brazil_beef_2015
• cd_brazil_chicken_2017_3
• beef_2016_3
• cd_brazil_2017_40001_45000
• cd_brazil_2017_30001_35000
• master_2016_90001_95000
• master_2015_60001_65000
• cd_brazil_2017_25001_30000
• master_2016_15001_20000
• palm_2018
• beef_2017_3
• trasesei-49792-brazil2016cotton3_1524595722158
• master_2015_80001_85000
• master_2016_60001_65000
• master_2015_55001_60000
• beef_2017_1
• cd_brazil_beef_2018
• master_2016_120001_125000
• master_2016_40001_45000
• master_2016_50001_55000
• beef_2018_2 (1)
• master_2016_70001_75000
• master_2015_50001_55000
• master_2016_25001_30000

No called script or script source not found.

import pandas as pd


def model(dbt, cursor):
    dbt.source("trase-storage-raw", "master_2015_65001_70000")
    dbt.source("trase-storage-raw", "chicken_2018")
    dbt.source("trase-storage-raw", "coffee_2015_2")
    dbt.source("trase-storage-raw", "cotton_2018")
    dbt.source("trase-storage-raw", "soy_2018")
    dbt.source("trase-storage-raw", "brazil_cotton_2015_5001_10000")
    dbt.source("trase-storage-raw", "master_2015_110001_115000")
    dbt.source("trase-storage-raw", "master_2015_115001_120000")
    dbt.source("trase-storage-raw", "master_2015_45001_50000")
    dbt.source("trase-storage-raw", "pork_2018")
    dbt.source("trase-storage-raw", "beef_2015_3")
    dbt.source("trase-storage-raw", "master_2015_1_5000")
    dbt.source("trase-storage-raw", "cd_8_2018")
    dbt.source("trase-storage-raw", "cd_brazil_2017_75001_80000")
    dbt.source("trase-storage-raw", "cd_3_2018")
    dbt.source("trase-storage-raw", "master_2015_105001_110000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_85001_90000")
    dbt.source("trase-storage-raw", "master_2015_120001_125000")
    dbt.source("trase-storage-raw", "coffee_2015_3")
    dbt.source("trase-storage-raw", "master_2015_40001_45000")
    dbt.source("trase-storage-raw", "beef_2015_1")
    dbt.source("trase-storage-raw", "master_2016_135001_140000")
    dbt.source("trase-storage-raw", "master_2015_5001_10000")
    dbt.source("trase-storage-raw", "master_2015_90001_95000")
    dbt.source("trase-storage-raw", "master_2015_130001_135000")
    dbt.source("trase-storage-raw", "master_2016_10001_15000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_70001_75000")
    dbt.source("trase-storage-raw", "master_2016_30001_35000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_15001_20000")
    dbt.source("trase-storage-raw", "cd_brazil_chicken_2017_2")
    dbt.source("trase-storage-raw", "master_2016_130001_135000")
    dbt.source("trase-storage-raw", "cd_brazil_coffee_2015")
    dbt.source("trase-storage-raw", "master_2015_30001_35000")
    dbt.source("trase-storage-raw", "cane_2018")
    dbt.source("trase-storage-raw", "master_2015_95001_100000")
    dbt.source("trase-storage-raw", "master_2015_70001_75000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_45001_50000")
    dbt.source("trase-storage-raw", "master_2016_35001_40000")
    dbt.source("trase-storage-raw", "beef_2017_2")
    dbt.source("trase-storage-raw", "master_2015_15001_20000")
    dbt.source("trase-storage-raw", "coffee_2016_3")
    dbt.source("trase-storage-raw", "cd_brazil_2017_1_5000")
    dbt.source("trase-storage-raw", "trasesei-49782-brazil2016cotton1_1524593044251")
    dbt.source("trase-storage-raw", "cd_brazil_2017_90001_95000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_5001_10000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_10001_15000")
    dbt.source("trase-storage-raw", "master_2015_20001_25000")
    dbt.source("trase-storage-raw", "master_2016_105001_110000")
    dbt.source("trase-storage-raw", "master_2016_110001_115000")
    dbt.source("trase-storage-raw", "cd_brazil_beef_2016")
    dbt.source("trase-storage-raw", "coffee_2016_2")
    dbt.source("trase-storage-raw", "brazil_cotton_2015_1_5000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_60001_65000")
    dbt.source("trase-storage-raw", "master_2016_140001_140056")
    dbt.source("trase-storage-raw", "master_2016_75001_80000")
    dbt.source("trase-storage-raw", "cd_4_2018")
    dbt.source("trase-storage-raw", "beef_2016_2")
    dbt.source("trase-storage-raw", "cd_6_2018")
    dbt.source("trase-storage-raw", "cd_1_2018")
    dbt.source("trase-storage-raw", "cd_5_2018")
    dbt.source("trase-storage-raw", "beef_2018_2")
    dbt.source("trase-storage-raw", "coffee_2017_1")
    dbt.source("trase-storage-raw", "master_2015_85001_90000")
    dbt.source("trase-storage-raw", "corn_2018")
    dbt.source("trase-storage-raw", "beef_2018_1")
    dbt.source("trase-storage-raw", "master_2016_100001_105000")
    dbt.source("trase-storage-raw", "master_2016_115001_120000")
    dbt.source("trase-storage-raw", "master_2016_80001_85000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_80001_85000")
    dbt.source("trase-storage-raw", "master_2016_1_5000")
    dbt.source("trase-storage-raw", "master_2016_5001_10000")
    dbt.source("trase-storage-raw", "cd_brazil_coffee_2017")
    dbt.source("trase-storage-raw", "cd_brazil_2017_95001_99554")
    dbt.source("trase-storage-raw", "cd_brazil_chicken_2017")
    dbt.source("trase-storage-raw", "master_2015_135001_139457")
    dbt.source("trase-storage-raw", "master_2015_10001_15000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_20001_25000")
    dbt.source("trase-storage-raw", "trasesei-49783-brazil2016cotton2_1524593193134")
    dbt.source("trase-storage-raw", "master_2016_65001_70000")
    dbt.source("trase-storage-raw", "master_2016_20001_25000")
    dbt.source("trase-storage-raw", "master_2016_95001_100000")
    dbt.source("trase-storage-raw", "cd_2_2018")
    dbt.source("trase-storage-raw", "cd_brazil_2017_55001_60000")
    dbt.source("trase-storage-raw", "beef_2017_4")
    dbt.source("trase-storage-raw", "cd_brazil_beef_2017")
    dbt.source("trase-storage-raw", "beef_2016_1")
    dbt.source("trase-storage-raw", "cd_9_2018")
    dbt.source("trase-storage-raw", "master_2016_45001_50000")
    dbt.source("trase-storage-raw", "cd_7_2018")
    dbt.source("trase-storage-raw", "master_2015_35001_40000")
    dbt.source("trase-storage-raw", "master_2015_125001_130000")
    dbt.source("trase-storage-raw", "master_2016_125001_130000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_35001_40000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_50001_55000")
    dbt.source("trase-storage-raw", "timber_2018")
    dbt.source("trase-storage-raw", "master_2015_75001_80000")
    dbt.source("trase-storage-raw", "master_2015_100001_105000")
    dbt.source("trase-storage-raw", "master_2016_55001_60000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_65001_70000")
    dbt.source("trase-storage-raw", "brazil_cotton_2015_10001_11245")
    dbt.source("trase-storage-raw", "master_2015_25001_30000")
    dbt.source("trase-storage-raw", "master_2016_85001_90000")
    dbt.source("trase-storage-raw", "cd_brazil_coffee_2016")
    dbt.source("trase-storage-raw", "beef_2015_2")
    dbt.source("trase-storage-raw", "coffee_2017_2")
    dbt.source("trase-storage-raw", "coffee_2015_1")
    dbt.source("trase-storage-raw", "coffee_2016_1")
    dbt.source("trase-storage-raw", "cd_brazil_chicken_2017_1")
    dbt.source("trase-storage-raw", "cd_brazil_beef_2015")
    dbt.source("trase-storage-raw", "cd_brazil_chicken_2017_3")
    dbt.source("trase-storage-raw", "beef_2016_3")
    dbt.source("trase-storage-raw", "cd_brazil_2017_40001_45000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_30001_35000")
    dbt.source("trase-storage-raw", "master_2016_90001_95000")
    dbt.source("trase-storage-raw", "master_2015_60001_65000")
    dbt.source("trase-storage-raw", "cd_brazil_2017_25001_30000")
    dbt.source("trase-storage-raw", "master_2016_15001_20000")
    dbt.source("trase-storage-raw", "palm_2018")
    dbt.source("trase-storage-raw", "beef_2017_3")
    dbt.source("trase-storage-raw", "trasesei-49792-brazil2016cotton3_1524595722158")
    dbt.source("trase-storage-raw", "master_2015_80001_85000")
    dbt.source("trase-storage-raw", "master_2016_60001_65000")
    dbt.source("trase-storage-raw", "master_2015_55001_60000")
    dbt.source("trase-storage-raw", "beef_2017_1")
    dbt.source("trase-storage-raw", "cd_brazil_beef_2018")
    dbt.source("trase-storage-raw", "master_2016_120001_125000")
    dbt.source("trase-storage-raw", "master_2016_40001_45000")
    dbt.source("trase-storage-raw", "master_2016_50001_55000")
    dbt.source("trase-storage-raw", "beef_2018_2 (1)")
    dbt.source("trase-storage-raw", "master_2016_70001_75000")
    dbt.source("trase-storage-raw", "master_2015_50001_55000")
    dbt.source("trase-storage-raw", "master_2016_25001_30000")

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

• Dbt path: trase_production.main_brazil.cd_brazil_2018

• Containing yaml link: trase/data_pipeline/models/brazil/trade/cd/dashboard/out/_schema.yml

• Model file: trase/data_pipeline/models/brazil/trade/cd/dashboard/out/cd_brazil_2018.py

• Original dbt_docs

• Tags: mock_model, brazil, cd, dashboard, out, trade