Skip to content

Postgres Commodities

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

Dbt path: trase_production.main_postgres_tables.postgres_commodities

Explore on Metabase: Full table; summary statistics

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

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

Dbt test runs & lineage: Test results ยท Lineage

Full dbt_docs page: Open in dbt docs (includes lineage graph -at the bottom right-, tests, and downstream dependencies)

Tags: postgres, commodities


postgres_commodities

Description

Queries the Postgres 'views.commodities' view


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 dependencies recorded.

No called script or script source not found.

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

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