Diet Trase Coffee 2020 Other

s3://trase-storage/diet-trase/results/diet-trase-results-2020-other.parquet

Dbt path: trase_production.main.diet_trase_coffee_2020_other

Explore on Metabase: Full table; summary statistics

Containing yaml file link: trase/data_pipeline/models/diet_trase/results/_schema_diet_trase_coffee_results.yml

Model file link: trase/data_pipeline/models/diet_trase/results/diet_trase_coffee_2020_other.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: gold, coffee, diet-trase-coffee

diet_trase_coffee_2020_other

Description

Results of the supply chain model for Diet Trase coffee in 2020 for all countries

Details

ColumnsDepends OnModel code

Column	Type	Description
`year`	`BIGINT`
`mass_tonnes_raw_equivalent`	`DOUBLE`
`padded_type`	`VARCHAR`
`port_of_export_name`	`VARCHAR`
`country_of_production_name`	`VARCHAR`
`branch`	`VARCHAR`
`status`	`VARCHAR`
`linear_programming_failure_reason`	`VARCHAR`
`is_domestic`	`BOOLEAN`
`domestic_consumption_region_geocode`	`VARCHAR`
`production_geocode`	`VARCHAR`
`domestic_consumption_region_gadm_level`	`DOUBLE`
`domestic_consumption_region_name`	`VARCHAR`
`_id`	`BIGINT`

Models / Seeds

source.trase_duckdb.trase-storage-raw.diet_trase_coffee_population_2020
source.trase_duckdb.trase-storage-raw.diet_trase_coffee_2020_costmatrix_jur2jur
source.trase_duckdb.trase-storage-raw.diet_trase_coffee_2020_costmatrix_jur2port
model.trase_duckdb.diet_trase_subnational_regions
model.trase_duckdb.diet_trase_coffee_trade_padded_2020
model.trase_duckdb.diet_trase_full_coffee_production_2020

Sources

['trase-storage-raw', 'diet_trase_coffee_population_2020']
['trase-storage-raw', 'diet_trase_coffee_2020_costmatrix_jur2jur']
['trase-storage-raw', 'diet_trase_coffee_2020_costmatrix_jur2port']

No called script or script source not found.

from trase.models.diet_trase.coffee_fullmodel.run_using_dbt import run


def model(dbt, cursor):
    dbt.config(materialized="external")

    # provide the SupplyChain class with data from DBT rather than allowing it to
    # read from S3. The keys in the dictionary relate to the "outname" properties of the
    # classes in trase/models/diet_trase/coffee_fullmodel/preparation.py
    data = {
        "jurisdictions": dbt.ref("diet_trase_subnational_regions").df(),
        "flows": dbt.ref("diet_trase_coffee_trade_padded_2020").df(),
        "production": dbt.ref("diet_trase_full_coffee_production_2020").df(),
        "population": dbt.source(
            "trase-storage-raw", "diet_trase_coffee_population_2020"
        ).df(),
        "distance_matrix_jur_jur": dbt.source(
            "trase-storage-raw", "diet_trase_coffee_2020_costmatrix_jur2jur"
        ).df(),
        "distance_matrix_jur_port": dbt.source(
            "trase-storage-raw", "diet_trase_coffee_2020_costmatrix_jur2port"
        ).df(),
    }

    return run(data, exclude=["BRAZIL", "TANZANIA"])