DBT: Postgres Regions Without Geometry

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

DBT model name: postgres_regions_without_geometry

Explore on Metabase: Full table; summary statistics

DBT details

• Lineage

• Test results

• Dbt path: trase_production.main.postgres_regions_without_geometry

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

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

• Original dbt_docs

• Tags: postgres, regions

---

Description

Queries the Postgres 'views.regions' table, but excludes the geometry column, to minimise the file size

---

Details

ColumnsDepends OnModel code

Column	Type	Description
name	VARCHAR
trase_id	VARCHAR
synonyms	VARCHAR[]
node_id	BIGINT
country	VARCHAR
region_type	VARCHAR
level	INTEGER
node_type_slug	VARCHAR
year_start	DOUBLE
year_end	DOUBLE
biome	VARCHAR
brazil_port_urf_codes	VARCHAR[]
matopiba	BOOLEAN
last_refresh_time	TIMESTAMP WITH TIME ZONE
node_type_name	VARCHAR
parent_trase_id	VARCHAR
parent_name	VARCHAR
parent_node_type_slug	VARCHAR
parent_node_type_name	VARCHAR

**Macros**

- `macro.trase_duckdb.attach_postgres`

- `macro.trase_duckdb.detach_postgres`

No called script or script source not found.

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

SELECT * EXCLUDE (_geometry) FROM {{ this.identifier }}_postgres_db.views.regions