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

Heads up — this asset has failing data tests

2 errors. See the Data Tests tab below.

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 column Test name Failing rows Last test run Last status Query in Metabase
Whole table test database_contains_all_indonesian_kabupaten — 2026-07-07 15:14 error 🔍 run query
Whole table test database_contains_all_indonesian_provinces — 2026-07-07 15:14 error 🔍 run query

Models

Macros

No called script or script source not found.

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

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