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 name Test column Last test run Last status
check_bol_against_comtrade_gold_cote_divoire_coffee_2020_CIV__0901_2101__mass_tonnes__2020 `` 2026-04-25 13:23 error
check_trader_groups_gold_cote_divoire_coffee_2020_exporter_group_name__2020 `` 2026-04-25 13:23 pass
relationships_gold_cote_divoire_coffee_2020_country_of_destination__country_name__ref_postgres_countries_ country_of_destination 2026-04-25 13:23 pass

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