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