Postgres Regions Without Geometry
s3://trase-storage/postgres_views/postgres_regions.parquet
Dbt path: trase_production.main_postgres_tables.postgres_regions_without_geometry
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_regions_without_geometry.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, regions
postgres_regions_without_geometry
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 |
No dependencies recorded.
No called script or script source not found.
{{ config(materialized='external') }}
SELECT * EXCLUDE (_geometry) FROM {{ this.identifier }}_postgres_db.views.regions