Warehouse and data lakehouses are converging and Db2 is ready for this shift. Db2 Datalake tables enable access to open-format data stored on remote object storage directly from within the relational database, eliminating the need for complex ETL pipelines or data duplication. This session explores the technical architecture supporting both Hive (ODF) and Iceberg table formats, demonstrating how organizations can query PARQUET, ORC, AVRO, and TEXTFILE data alongside traditional Db2 tables in complex SQL queries while maintaining ACID properties where needed. Attendees will learn implementation strategies for converged warehouse architectures, performance optimization techniques, and real-world use cases where Datalake tables provide bidirectional data flow between relational databases and data lake / lakehouses.
