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

DBT details

• Lineage

• Test results

• 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

---

Description

Queries the Postgres 'views.commodities' view

---

Details

ColumnsDepends OnModel code

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

**Macros**

- `macro.trase_duckdb.attach_postgres`

- `macro.trase_duckdb.detach_postgres`

No called script or script source not found.

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

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