Articles by tag: etl

Column Sum Control in Python | Pandas Function

How to Track Column Sum Changes in pandas Using the det_sum Function. Automate Data Monitoring and Detect Anomalies in ETL Processes.

Calculation View in asapBI without SQL

Learn how to visually build analytical models in asapBI for ADB, PostgreSQL and Trino. Export to UDF, clusters without load on DB. For DWH developers.

DuckDB as storage: replacing ETL Postgres

Learn how DuckDB replaces ETL + Postgres with one file for OLAP. Code examples, SLA, migration. Simplify analytics without infrastructure — read the guide for developers.

ClickHouse with Airflow instead of PostgreSQL for Big Data

Learn why Airflow + ClickHouse is displacing PostgreSQL in analytics. Performance comparison, examples for data engineers. Switch to columnar DB for ETL pipelines.

Big Data Courses 2026: Data Engineering Overview

Comparison of 6 Big Data and Data Engineering courses: from zero to middle. ETL, Spark, Kafka, Yandex Cloud. Choose a program by level and format for a career in 2026. Sign up now.

ETL Architecture: asapBI, Trino, Spark, Airflow for data engineers

How asapBI combines Trino, Spark, and Airflow into a single interface for ETL processes. Code autogeneration, orchestration, and Open Source solutions for data engineers.