Skip to content

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

Explore dependencies/lineage: link

Description

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

Details

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

Review full report including sample errors records if they exist (link)

Test name Test column Last test run Last status
database_contains_all_indonesian_kabupaten `` 2026-04-25 13:23 error
database_contains_all_indonesian_provinces `` 2026-04-25 13:23 error

Models

Macros

No called script or script source not found.

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

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