Gold Cote Divoire Coffee 2020

s3://trase-storage/cote_divoire/coffee/trade/bol/gold/gold_cote_divoire_coffee-2020.parquet

Dbt path: trase_production.main_cote_divoire_coffee.gold_cote_divoire_coffee_2020

Explore on Metabase: Full table; summary statistics

Containing yaml file link: trase/data_pipeline/models/cote_divoire/coffee/trade/_schema_cote_divoire_coffee.yml

Model file link: trase/data_pipeline/models/cote_divoire/coffee/trade/gold_cote_divoire_coffee_2020.sql

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, cote_divoire, coffee, trade, 2020, diet-trase-coffee

gold_cote_divoire_coffee_2020

Description

Loads only the gold required fields and does basic constraint checks

Details

ColumnsDepends OnModel code

Column	Type	Description
`year`	`INTEGER`
`exporter_label`	`VARCHAR`
`exporter_node_id`	`BIGINT`
`exporter_group_name`	`VARCHAR`
`country_of_destination`	`VARCHAR`
`mass_tonnes`	`DOUBLE`
`fob`	`DOUBLE`
`importer_label`	`VARCHAR`
`port_of_export_label`	`VARCHAR`
`hs6`	`VARCHAR`

Models / Seeds

model.trase_duckdb.pre_gold_cote_divoire_coffee_2020

No called script or script source not found.

-- gold_cote_divoire_coffee_2020
{{ 
    config(materialized='external')
}}

SELECT
    year,
    exporter_label,
    trader_node_id AS exporter_node_id,
    exporter_group_name,
    country_of_destination,
    mass_tonnes,
    fob,
    importer_label,
    port_of_export_label,
    hs6
FROM 
    {{ ref('pre_gold_cote_divoire_coffee_2020')}}