Data Vault and Star Schema with PlantUML: Entity Relationship Diagram as Code
Entity Relationship Diagram as code means developers use the same tools for creating the diagrams...
Read More
Author: abuData
Materialization examples of Data Engineering with dbt
dbt offers several materialization options to create ETL/ELT processes. The article shows and...
Read More
Data Engineering with dbt – first steps using PostgreSQL and Oracle
dbt is a Data Engineering tool supporting version control with CI/CD for transformations and...
Read More
PostgreSQL application_name
PostgreSQL application_name can be set in the connection string. The view pg_stat_activity will...
Read More
PostgreSQL columnar extension cstore_fdw
PostgreSQL columnar extension cstore_fdw is a storage extension which is suited for...
Read More