#data-warehouse

ART TCH

SE Sendoa Moronta

The Hard Parts of Dimensional Modeling

Grain, multi-valued dimensions, temporal facts and the edge cases that break otherwise correct analytical models

Aug 11, 2026 · 11 min read · 0 claps paywalled #data-engineering #data-architecture #data-modeling

ART TCH ECO

CH Chirag Venkateshaiah

Bronze, and the confidently wrong fix

Where the schema tells you it’s fine and isn’t — plus the pivot that reversed a decision I’d pinned in writing specifically so it wouldn’t…

Aug 04, 2026 · 7 min read · 1 claps #software-development #databricks #data-warehouse

TCH

IR Iryna Bundzylo

I Tested Four Databricks ETL Tools, So You Don’t Have To

One migration, four tools, and a lot of notes on who complained the most along the way.

Jul 28, 2026 · 6 min read · 0 claps #etl #etl-tool #databricks

AI MKT TCH SPT SCI

MA Marco Ciavarella

The $600 Slack Ping: What Happens When You Point a Coding Agent at Your Warehouse

Autonomous coding agents are running wild on datawarehouses, racking up hundred dollar bills in seconds. Agentic tooling for Analytics…

Jul 15, 2026 · 5 min read · 0 claps #analytics-engineering #data-warehouse #vibe-coding

TCH

FE Feroz Mulla · Towards Data Engineering

BigQuery Cost Optimization: A Comprehensive Guide

BigQuery is a powerful Data platform that enables you to create peta-byte scale Data Warehouses, Performant Data Marts, Open format…

Jul 15, 2026 · 9 min read · 0 claps #bigquery #google-cloud-platform #data-warehouse

TCH HUM MKT

SA Sai Akash

Your Data Warehouse Is Perfect. So Why Does Finance Still Hate It?

Your Data Warehouse Is Perfect. So Why Does Finance Still Hate It?

Jul 15, 2026 · 3 min read · 10 claps #data-engineering #data #data-warehouse

ART TCH

SH Shadchika_Banu

Data Warehouse vs Snowflake: Architecture, Features, and Differences

Data warehouse

Jul 15, 2026 · 3 min read · 0 claps #data-warehouse #cloud-data-warehouse #snowflake

TCH MDA

AB Abu Mohammad Tariqul Ismail

Star Schema in Practice ⭐ Build Data Models People Can Actually Query

🚨 Bad data modeling doesn’t fail loudly. It shows up as slow dashboards, bloated cloud bills, and “why does this number look wrong?” at…

Jul 15, 2026 · 3 min read · 0 claps #data-analysis #data-warehouse

MDA

CH Chaithanya Das

Data Lineage Tracking Shows Where Every Record Came From

Ask a data team where a single number on an executive dashboard actually came from, and watch how quickly the confidence drains from the…

Jul 14, 2026 · 8 min read · 0 claps #data-lineage #data-warehouse #data-liabilities

TCH MKT

SA Sai Akash

The Silent Layer That Keeps Your Data Warehouse From Falling Apart | Data Engineering Fundamentals…

Meet the Staging Layer: the unsung hero every data pipeline secretly depends on

Jul 13, 2026 · 2 min read · 0 claps #data-engineering #data-warehouse #business-intelligence

TCH

RE René Luijk · Data Engineer Things

dbt Incremental Models vs. Snowflake Dynamic Tables

Catching late-arriving data, data freshness, and orchestration

Jul 13, 2026 · 9 min read · 18 claps #snowflake #dbt #data-warehouse

TCH MKT AI SCI

SA Saideep Uikey

The Data Engineer’s Guide to Slowly Changing Dimensions: Striking the Balance Between Cost and…

In data engineering, change is the only constant. Entities like users, products, and regions evolve over time. A customer moves to a new…

Jul 13, 2026 · 3 min read · 0 claps #data-engineering #data-science #data-warehouse

TCH AI SCI

DA David Naranjo Ramírez

100.000 pedidos me contaron por qué sus clientes no vuelven

Lo que aprendí construyendo un Data Warehouse de e-commerce durante mi Máster en Data Science en Evolve

Jul 12, 2026 · 4 min read · 0 claps #postgresql #data-warehouse #sql

TCH SCI

AR Arzu

Before AI, You Need Data: Understanding Data Warehouses and the Modern Data Stack

A Physics Engineer’s Journey into Data & AI

Jul 12, 2026 · 10 min read · 0 claps #database #data-warehouse #data-lake

TCH

HE Henry · Data Engineer Things

dbt Snapshots Explained: Track How Your Data Changes Over Time [dbt Series #6]

A hands-on guide to building Type 2 slowly changing dimensions with dbt and DuckDB

Jul 10, 2026 · 10 min read · 71 claps paywalled #data-engineering #sql #data-modeling

TCH

CH Chris Bateson

A Practical Guide to Cutting Cloud Data Warehouse Expenses in 2026

Cloud data warehouses have now been firmly established as mission critical systems for many organizations. Why? Well, they are what powers…

Jul 08, 2026 · 3 min read · 0 claps #data-warehouse #cloud-data-warehouse #data-warehousing

AI TCH MDA

WE Wes Duenow

SignalForge now speaks Databricks: pruning AI-generated dbt tests against your lakehouse

Databricks is now a first-class SignalForge warehouse, with full sampling, Unity Catalog, cost estimation, the works. The interesting part…

Jul 06, 2026 · 6 min read · 0 claps #dbt #data-engineering #airflow

TCH AI SCI

BR Braeson

Slowly Changing Dimensions(SCDs) with examples; Complete Guide

What are dimensions?

Jul 05, 2026 · 4 min read · 0 claps #data-science #data-engineering #data-warehouse

ART TCH

JO Joachim Hodana · Data Engineer Things

What breaks your Snowflake pipeline at 100M+ rows

Pipelines that process a few million rows rarely reveal architectural problems. Snowflake is fast, warehouses auto-suspend, dbt models…

Jul 03, 2026 · 8 min read · 21 claps #snowflake #sql #data-warehouse

ART TCH

KA Kavika Roy · DataToBiz

Aiding Modern Enterprises, DataToBiz Rolls Out a Scalable Lakehouse Architecture

Traditional data warehouses and lakes are reaching their limits, and time-consuming access to these is no longer acceptable in modern…

Jul 03, 2026 · 3 min read · 1 claps #data-lakehouse #data-architecture #modern-data-stack

ECO

PU Puga Sankara

Voice Evolves the Efficiency of the Warehouse

The first time I was confronted with the idea of voice picking, I was intrigued. This was quite a long time ago, but when I saw the design…

Jul 03, 2026 · 5 min read · 0 claps #data-warehouse #warehouse #warehouse-management

ECO

PU Puga Sankara

Designing User-Friendly Systems: Not as Easy as It Sounds

Recently, I got to chatting with a customer who asked me if we had ever considered adding a warehouse management system (WMS) to our…

Jul 03, 2026 · 3 min read · 0 claps #warehouse #data-warehouse #warehouse-management

TCH DSN

AL Albin Issac · Tech Learnings

Copy, Mirror, or Federate -Connecting Your Data to Adobe Experience Platform

Three ways to connect your cloud data warehouse to Adobe Experience Platform — Data Mirror, Federated Audience Composition, and Delta…

Jul 02, 2026 · 6 min read · 0 claps #data #adobe #customer-experience

SCI HUM

DR Dr Maria Cristina Caldarola

How do we want to shape our future digital space?

The digital space offers us worldwide, borderless, paperless, immediate reach, commerce and interaction with other people, cultures…

Jul 01, 2026 · 1 min read · 0 claps #duet-interview #data-warehouse #big-data

TCH MKT

RE René Luijk · Data Engineer Things

dbt Materializations: What Actually Happens to Your Data

The visualization I wish I got when starting out with dbt

Jun 29, 2026 · 5 min read · 7 claps #dbt #data-warehouse #sql

KB İkbal Arslan

Understanding Dimensional Modeling

For analysts and business users to query data quickly and meaningfully, the data must be organized in a way that supports analysis.

Jun 28, 2026 · 3 min read · 0 claps #dimensional-modeling #dimensional-model #data-warehouse

TCH HUM

MA Madhurima Nath, PhD

Slowly Changing Dimensions: Tracking Historical Data

A database table that records a customer’s address or a product’s category can simply overwrite the old value with the new one when it…

Jun 27, 2026 · 10 min read · 0 claps #data-engineering #slowly-changing-dimension #data-warehouse

TCH DSN

MO Moritz Weidner

Object Oriented Semantic Layer

Despite their intention, many data warehouse semantic layers in use today are cumbersome and lack any real abstraction. In this article I…

Jun 23, 2026 · 8 min read · 0 claps #semantic-layer #dbt #data-warehouse

TCH

HE Henry · Level Up Coding

DBT Seeds Explained: Stop Hardcoding Lookups in a Table in DBT [dbt Series #5]

A practical guide to loading reference data into your warehouse with dbt seed and joining it in staging models

Jun 22, 2026 · 8 min read · 77 claps paywalled #data-engineering #sql #data-modeling

TCH

AH Ahmed M Khan

Understanding Slowly Changing Dimensions (SCDs) in Data Warehousing: Types 0, 1, 2, 3, 4, 5, and 6

When building a data warehouse, one of the most common challenges is handling changes to business data over time.

Jun 21, 2026 · 5 min read · 1 claps #data-warehouse #data-engineering #slowly-changing-dimension

ECO

JT JTCIPHER

Inventory Software for Small Businesses: The Complete Guide for Growing Companies

Small businesses often start by managing inventory using spreadsheets, notebooks, WhatsApp messages, or simple accounting software.

Jun 20, 2026 · 3 min read · 0 claps #inventory-management #inventory-software #rfid

TCH

PW Pw

Data Warehouse Services: The Complete Guide to Choosing the Right Solution

Modern enterprises are drowning in data. Log files, transactional records, customer behavior streams, IoT signals the volume doubles every…

Jun 16, 2026 · 8 min read · 0 claps #data-warehouse #cloud-data-warehouse

ART TCH HUM AI

TE Teja Naidu

Understanding Snowflake Architecture: Storage, Compute, and Cloud Services Explained

Learning Snowflake Series | Topic 3

Jun 15, 2026 · 4 min read · 0 claps #snowflake #data-engineering #cloud-computing

TCH LIF

AB Abhishek Mittal

Snowflake Dynamic Tables: A Practical guide to building pipelines that run themselves

If you’ve ever spent a Saturday untangling a failed Airflow DAG, or babysat a multi-terabyte backfill while watching your compute budget…

Jun 15, 2026 · 14 min read · 20 claps #snowflake #snowflake-dynamic-table #data-engineering

TCH

AN Andreretorta

Construindo um Pipeline de Dados ETL com Pentaho PDI e Modelagem Dimensional

Da extração de arquivos CSV/XLSX e de um sistema OLTP em PostgreSQL à carga de um Data Mart de Vendas em Star Schema — um projeto completo…

Jun 14, 2026 · 37 min read · 0 claps #pentaho #etl #data-warehouse

TCH MKT

ZA Zaigam Akhtar · ILLUMINATION

What Is BigQuery?

Google’s Serverless Data Warehouse Explained

Jun 12, 2026 · 3 min read · 151 claps #bigquery #data-analytics #data-warehouse

SA Sagar Sisodia

The Riverhouse — A New Word for an Old Trade-Off

The data platform industry has been converging on something it doesn’t yet have a name for.

Jun 09, 2026 · 5 min read · 0 claps #riverhouse #lake-house #data-warehouse

BU Bull City Talent Group

SAP Datasphere vs. Traditional Data Warehousing: What Leaders Need to Know

For years, enterprise data strategy was anchored in a single question: How do we centralize everything into one high-performance warehouse…

Jun 09, 2026 · 2 min read · 0 claps #sap-datasphere #data-warehouse #data-warehousing

TCH

PU Purvajage

Understanding Data Lake vs Data Warehouse vs Data Lakehouse

During my Data Engineering internship, I started working with tools like HDFS, Jupyter Notebook, and Databricks while building data…

Jun 09, 2026 · 4 min read · 0 claps #data-engineering #data-lake #data-warehouse

AI SPT

NA Navyasree Potluri

Rewind Your Data: Understanding Time Travel in Microsoft Fabric Warehouses

Microsoft Fabric’s Time Travel capability allows you to query your data exactly as it existed at a specific point in time without…

Jun 09, 2026 · 5 min read · 0 claps paywalled #microsoft-fabric #time-travel #data-warehouse

TCH

LE Leo Leon

You’re Moving Data You Never Had to Move.

Five Snowflake patterns that quietly kill your external ETL — and the gotchas nobody warns you about.

Jun 08, 2026 · 4 min read · 0 claps paywalled #snowflake #data-engineering #etl

ART TCH ECO LIF

NA NARRUX Systems

Why Data Warehousing Is the Foundation of Algorithmic Trading

Most conversations about algorithmic trading focus on the algorithm — the model, the signal, the strategy. Almost none focus on what sits…

Jun 08, 2026 · 2 min read · 5 claps #data-engineering #algorithmic-trading #fintech

TCH AI SCI

KA Kanerika Inc

Data Warehouse Security in Microsoft Fabric: The Complete 2026 Guide

TLDR

Jun 08, 2026 · 15 min read · 0 claps #microsoft-fabric #data-warehouse #data-science

AI

TO Todd Fearn

The Agent Puts Data Where Its Shape Wants to Live

Ask an engineer where a new feed should land and you’ll get the answer before you finish the question. The warehouse. The lake. Whatever…

Jun 08, 2026 · 4 min read · 0 claps #ai #ai-agent #generative-ai-tools

TCH MKT

RI Ricardo Augusto Franco

Como decidir sua modelagem e entrega de dados

Star Schema vs One Big Table, quando engenharia de dados vira questão de virtude e esquecemos que a resposta está nos gargalos do negócio.

Jun 07, 2026 · 22 min read · 4 claps #data-engineering #data-modeling #analytics-engineering

ART TCH

FA Fahad Shamim

Medallion Architecture: A Practical Guide to Organizing Modern Data Platforms like MS Fabric

As organizations continue to grow their data footprint; ingesting from applications, files, IoT devices, and business systems; keeping that…

Jun 06, 2026 · 5 min read · 0 claps #medallion-architecture #msfabric #lakehouse-architecture

TCH ECO MKT

SE Sergey Kisly

Before You Choose a CDP, Data Warehouse or CRM, Look at What Is Already Broken

AI workflows and warehouse-native marketing tools have raised the cost of getting the build order wrong. If customer records, attribution…

Jun 05, 2026 · 5 min read · 0 claps #cdp #data-warehouse #crm

TCH

HE Henry · Level Up Coding

Your DBT pipeline ran, but Your Data Was Wrong. Here’s the Fix. [DBT Series #4]

A practical guide to DBT generic tests, singular tests, and model documentation that catches silent failures before your stakeholders do.

Jun 05, 2026 · 12 min read · 105 claps paywalled #dbt #data-engineering #sql

TCH

VA Vaishnavidesai

Complete Guide to Snowflake Streams and Tasks with Real-Time Examples

Introduction

Jun 05, 2026 · 2 min read · 1 claps #snowflake #dbt #data-warehouse

ECO

GE Gemilangtraining

Mengoptimalkan Persediaan Barang melalui Inventory Management

Ketersediaan dan stok barang merupakan salah satu aset penting yang mendukung kelancaran operasional perusahaan. Pengelolaan persediaan…

Jun 04, 2026 · 1 min read · 0 claps #inventory-management #data-warehouse #warehouse-management