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

Explore dependencies/lineage: link

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

Review full report including sample errors records if they exist (link)

Test column Test name Failing rows Last test run Last status Query in Metabase
Whole table test check_bol_against_comtrade_gold_cote_divoire_coffee_2020 — 2026-07-07 15:08 pass 🔍 run query
Whole table test check_trader_groups_gold_cote_divoire_coffee_2020_exporter_group_name__2020 — 2026-07-07 15:09 pass 🔍 run query
country_of_destination relationships_gold_cote_divoire_coffee_2020_country_of_destination__country_name__ref_postgres_countries_ — 2026-07-07 15:14 pass 🔍 run query

Models

Models

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