Parallel data extract in a simple wayIn this paper we will address a problem of slow data extraction, often encountered when working with legacy systems, and we will do it in a…Jan 27Jan 27
Published inDev GeniusEnd to end ELT process example for DW using Postgres.The purpose of this paper is mostly educational. It targets developers that are asked to build small to medium size data warehouse/mart, or…Dec 21, 2024Dec 21, 2024
SCD Type 2 process in Postgres : one script for allIntro: we will present one psql script capable of handling any SCD Type 2 dimension just by providing table name. Intended audience: data…Nov 4, 2024Nov 4, 2024
How to put an Airflow task “on ice”Airflow jobs (dags) can be disabled, we all know that. But can we disable an individual step in a job (task in a dag)? Or enable just one…Jan 17, 20211Jan 17, 20211