The Lakehouse and AI Show
Bite-sized, authoritative video deep dives into Data Lakehouse architecture, open table formats, Apache Iceberg, Apache Arrow, and AI data systems by Alex Merced.
1:54Ep #1Transactional vs Analyticsl systems - Data Lakehouse & AI w/ Alex Merced #1
Understanding the fundamental differences between OLTP (Transactional) and OLAP (Analytical) systems and how modern lakehouses bridge the gap.
2:01Ep #2ETL vs ELT - Data Lakehouse and AI with Alex Merced
Comparing Extract-Transform-Load (ETL) and Extract-Load-Transform (ELT) architectural patterns in modern data platforms.
3:03Ep #3Row based vs columnar data storage - Data Lakehouse and AI with Alex Merced #3
Why columnar storage layouts outperform traditional row-based storage formats for analytical workloads.
3:44Ep #4Components of a Data System - Data Lakehouse and AI with Alex Merced #4
Deconstructing the core layers of modern data architecture: storage, file format, table format, catalog, semantic layer, and compute engine.
2:51Ep #5The Interoperability Bottle Neck - Data Lakehouse and AI with Alex Merced #5
Exploring vendor lock-in and how open table formats solve the interoperability bottleneck across analytical compute engines.
3:01Ep #6What’s a Data Lakehouse? - Data Lakehouse and AI with Alex Merced #6
A clear definition of the Data Lakehouse: combining data warehouse ACID reliability with data lake scale and flexibility.
3:45Ep #7What is Apache Arrow - Data Lakehouse and AI with Alex Merced #7
Deep dive into Apache Arrow, the in-memory columnar data standard enabling zero-copy data transport and high-speed processing.
2:49Ep #8What is Apache Parquet - Data Lakehouse and AI with Alex Merced #8
Understanding Apache Parquet, its row group structure, column chunks, compression, and why it is the default format for lakehouses.
2:59Ep #9What is Apache Iceberg - Data Lakehouse and AI with Alex Merced #9
Introduction to Apache Iceberg: metadata layers, snapshot logs, manifest files, schema evolution, and ACID transactions.
2:24Ep #10What is Apache Polaris - Data Lakehouse and AI with Alex Merced #10
Exploring Apache Polaris (Incubating), the open-source REST catalog for Apache Iceberg providing multi-engine access control and governance.
1:31Ep #11What is Machine Learning - Data Lakehouse and AI with Alex Merced #11
What machine learning actually is: learning patterns from data instead of hand-coding rules, and how training data quality shapes the resulting model.
1:19Ep #12What is a Large Language Model - Data Lakehouse and AI with Alex Merced #12
Understanding Large Language Models: what they are, how they are trained on massive text corpora, and how they predict language to generate responses.
3:32Ep #13What are Vectors and Tokens - Data Lakehouse and AI with Alex Merced #13
Breaking down tokens and vectors — how text is split into tokens and represented as embeddings that capture meaning for search and AI workloads.
2:37Ep #14What are Context Windows - Data Lakehouse and AI with Alex Merced #14
What a context window is, why it limits how much information a model can consider at once, and what that means for prompting and retrieval design.
2:18Ep #15Prompt Engineering - Data Lakehouse and AI with Alex Merced #15
Prompt engineering fundamentals: how framing, context, and instructions shape the quality and reliability of the output you get from a language model.