Skip to content

DBT: Gold Uganda Coffee 2020

File location: s3://trase-storage/uganda/trade/bol/2020/gold/gold_uganda_coffee_2020.parquet

DBT model name: gold_uganda_coffee_2020

Explore on Metabase: Full table; summary statistics

DBT details

Description

.

Auto-generated docs for 'gold_uganda_coffee_2020'

Date this documentation was generated: 2024-12-16 20:03 CET

Basic S3 Information

  • S3 Location: s3://trase-storage/uganda/trade/bol/2020/gold/gold_uganda_coffee_2020.parquet
  • File Size: 0.13 MB
  • Last Updated: 2024-10-07 12:39:07+00:00
  • S3 Version Id: JRnyntWVUIoGwHttMRs4jEW.L0BlQC_n

Explore data in Metabase

Data Profile

column_name column_type min max approx_unique avg std q25 q50 q75 count null_percentage
year INTEGER 2020 2020 1 2020 0 2020 2020 2020 7326 0
exporter_label VARCHAR 32 CUP ZOEGAS KAFFEE,GRENADJARGATAN 6 559 7326 0
exporter_group_name VARCHAR 32 CUP ZOEGAS KAFFEE,GRENADJARGATAN 6 280 7326 0
country_of_destination VARCHAR ALBANIA YUGOSLAV SFR 41 7326 0
mass_tonnes DOUBLE 0.025 357.0 853 38.1558 32.9518 19.2584 21.6 42.2974 7326 0
fob DOUBLE 2.1169 5489303.566 4345 28829.3 81726.7 150.756 971.353 37616.9 7326 0
importer_label VARCHAR "ORIMI UKRAINE" LLC ZUKUKA BORA COFFEE COMPANY 1408 7326 0.08
port_of_export_label VARCHAR 0 7326 100
hs6 VARCHAR 090111 090111 1 7326 0

DBT Tests

To see detailed documentation of each test, go further below to the Referenced by -> Data Tests section

Compiled filename Link to run manually Number of records returned or failed
check_trader_groups_gold_ugand_fbf8c4611933e92e4035a0c9c61010ed.sql Metabase link 0
check_bol_against_comtrade_gol_ca9139e47370465bc6612403b9eed166.sql Metabase link 1
relationships_gold_uganda_coff_dca736c188b86878c3e469eef928d809.sql Metabase link 0
dbt_utils_expression_is_true_g_8aed8f0eea3cf7a7c4310c2b4263ce2d.sql Metabase link 0
accepted_values_gold_uganda_co_7a6ae4879fc6411323f36f3ea3c106bf.sql Metabase link 0
dbt_utils_expression_is_true_gold_uganda_coffee_2020_fob___0.sql Metabase link 0
not_null_gold_uganda_coffee_2020_fob.sql Metabase link 0
not_null_gold_uganda_coffee_2020_mass_tonnes.sql Metabase link 0
not_null_gold_uganda_coffee_2020_hs6.sql Metabase link 0

Details

Column Type Description
year INTEGER
exporter_label VARCHAR
exporter_node_id DOUBLE
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.silver_uganda_coffee_2020

No called script or script source not found.

# gold_uganda_coffee_2020
from trase.data.uganda.gold_uganda_coffee_2020 import get_gold_uganda_coffee_2020


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

    # Declaring the sources so they appear in the documentation / lineage
    silver_trade_data = dbt.ref("silver_uganda_coffee_2020")

    df = get_gold_uganda_coffee_2020()

    final_data = session.sql(
        f"""
        WITH final_fields AS (
            SELECT
                YEAR::INT AS year,
                EXPORTER_NAME AS exporter_label,
                EXPORTER_ID AS exporter_node_id,
                EXPORTER_GROUP AS exporter_group_name,
                COUNTRY_DESTINATION AS country_of_destination,
                NET_WEIGHT/1000 AS mass_tonnes,
                CIF_VALUE_AMT_USD AS fob,
                BUYER_NAME AS importer_label,
                NULL::VARCHAR AS port_of_export_label,
                CAST(HS_CODE[0:6] AS VARCHAR) AS hs6
            FROM df
            WHERE
                (HS6 LIKE '0901%' OR HS6 LIKE '2101%')
        )
        SELECT * FROM final_fields    
    """
    ).arrow()

    return final_data