Skip to content

DBT: Gold Cote Divoire Coffee 2020

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

DBT model name: gold_cote_divoire_coffee_2020

Explore on Metabase: Full table; summary statistics

DBT details


Description

Loads only the gold required fields and does basic constraint checks


Details

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')}}