DBT: Postgres Commodities

File location: s3://trase-storage/postgres_views/postgres_commodities.parquet

DBT model name: postgres_commodities

Explore on Metabase: Full table; summary statistics

Explore dependencies/lineage: link

---

Description

Queries the Postgres 'views.commodities' view

---

Details

ColumnsData TestsReferenced ByDepends OnModel codeDBT details

Column	Type	Description
commodity	VARCHAR
product_type	VARCHAR
product_unit	VARCHAR
location	VARCHAR
location_trase_id	VARCHAR
year	DOUBLE
hs_code	VARCHAR
eq_factor	DOUBLE
last_refresh_time	TIMESTAMP WITH TIME ZONE

No data tests defined 🧐

Models

• beef_auxiliary_cnpj_2021
• beef_auxiliary_cnpj_2022
• beef_auxiliary_cnpj_2023
• brazil_bol_2023_silver
• brazil_mdic_municipality_2020
• brazil_mdic_municipality_2021
• brazil_mdic_municipality_2022
• brazil_mdic_municipality_2023
• brazil_mdic_municipality_2024
• brazil_mdic_port_2020
• brazil_mdic_port_2021
• brazil_mdic_port_2022
• brazil_mdic_port_2023
• brazil_mdic_port_2024
• diet_trase_coffee_trade_padded_2020

Exposures

• brazil_beef_municipalities (view exposure, view documentation)
• qa_bol_2021_2023BR_BOL_COMTRADE_MDIC_BEEF (view exposure, view documentation)

Macros

• attach_postgres
• detach_postgres

No called script or script source not found.

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

SELECT * FROM {{ this.identifier }}_postgres_db.views.commodities

• Dbt path: trase_production.main.postgres_commodities

• Containing yaml link: trase/data_pipeline/models/postgres_views/_schema_postgres_tables.yml

• Model file: trase/data_pipeline/models/postgres_views/postgres_commodities.sql

• Original dbt_docs

• Tags: postgres, commodities