DBT: Postgres Logistics

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

DBT model name: postgres_logistics

Explore on Metabase: Full table; summary statistics

DBT details

• Lineage

• Test results

• Dbt path: trase_production.main_postgres_tables.postgres_logistics

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

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

• Original dbt_docs

• Tags: postgres, logistics

---

Description

Extracts logistics data from Postgres 'views.logistics' table, excluding 'asset_geometry' field.

---

Details

ColumnsDepends OnModel code

Column	Type	Description
ref_id	INTEGER
version	VARCHAR
link_id	BIGINT
country_of_production	VARCHAR
commodity	VARCHAR
year_start	DOUBLE
year_end	DOUBLE
region_1	VARCHAR
region_1_trase_id	VARCHAR
region_2	VARCHAR
region_2_trase_id	VARCHAR
asset	VARCHAR
asset_type	VARCHAR
asset_sub_type	VARCHAR
asset_trase_id	VARCHAR
asset_latitude	DOUBLE
asset_longitude	DOUBLE
asset_capacity	DOUBLE
asset_capacity_unit	VARCHAR
slaughterhouse_subclass	VARCHAR
slaughterhouse_inspection_level	VARCHAR
trader	VARCHAR
trader_id	BIGINT
trader_trase_id	VARCHAR
trader_group	VARCHAR
trader_group_id	BIGINT

**Macros**

- `macro.trase_duckdb.attach_postgres`

- `macro.trase_duckdb.detach_postgres`

No called script or script source not found.

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

SELECT * EXCLUDE (asset_geometry)
FROM {{ this.identifier }}_postgres_db.views.logistics