Data Engineering Podcast
Using Trino And Iceberg As The Foundation Of Your Data Lakehouse
Podcast summary created with Snipd AI
Quick takeaways
- Combining Trino and Iceberg simplifies building a Data Lake house with powerful analytics and stable storage.
- DAGS-TUR offers a new approach to data platform orchestration with integrated lineage, observability, and testability.
- Future Data Lake advancements include real-time data updates and integration of fast-moving data feeds.
Deep dives
DAGS-TUR: A New Approach to Building and Running Data Platforms
DAGS-TUR is an open source, cloud native orchestrator for data platforms that offers integrated lineage and observability, a declarative programming model, and testability. It provides a new approach to building and running data pipelines, allowing teams to get started quickly with enterprise-class hosted solutions. DAGS-TUR Cloud offers serverless and hybrid deployments, enhanced security, and on-demand test deployments. Data Lakes are complex, but DAGS-TUR simplifies the process of building and scaling high-quality data workflows. Try DAGS-TUR Cloud for free at DataEngineeringPodcast.com.
Starburst: Powering Petabyte-Scale SQL Analytics
Starburst is a Data Lake analytics platform that powers petabyte-scale SQL analytics with speed and cost-efficiency. Trusted by companies like Comcast and DoorDash, Starburst delivers adaptability and flexibility in the data Lake house ecosystem. With first-class support for Apache iceberg, Delta Lake, and Hoodie, Starburst enables the use of Trino for fast and accurate data analytics. Experience Starburst in action at DataEngineeringPodcast.com and get $500 in credits to try Starburst Galaxy, the easiest way to get started with Trino.
Building a Data Lake House with Trino and Iceberg
The Data Engineering Podcast interviews Dane Sundstrom, CTO at Starburst, about building a Data Lake house with Trino and Iceberg. Dane discusses his experience in the Data Lake space and explains the concept of a Data Lake house, which combines standard data storage with a Lake house approach. Trino serves as a powerful analytics and query engine, while Iceberg provides a stable and well-defined storage format. Dane highlights the benefits of this combination, such as enhanced performance and adaptability for large-scale data analytics. Join the open data lakes community and leverage Trino and Iceberg for your data workflows.
The Challenges of Security and Access Control in Data Lake Houses
Dane Sundstrom, CTO at Starburst, reveals the challenges of security and access control in Data Lake houses. He emphasizes the complexity of the security space and the lack of standardized solutions, especially in the open ecosystem. While proprietary systems exist, Dane encourages the open community to come up with improved approaches. He describes the limitations of current security models and the need for better integration and tooling. Dane also outlines the difficulties in maintaining security systems across different platforms and the importance of aligning security implementation with specific requirements.
The Future of Data Lakes: Real-Time Data Updates and Fast Moving Data
In the future of Data Lakes, Dane Sundstrom envisions advancements in real-time data updates and fast moving data. The open data lakes community is exploring the integration of fast moving data feeds, such as Apache Kafka, with Data Lake architectures. This enables near real-time ingestion of data and efficient manipulation of up-to-date feeds. Dane also acknowledges the need for better tools and solutions to handle complex data transformations and reflect changes in real time. As the open data lakes evolve, the community strives to bridge the gap between fast-moving streaming data and traditional batch processing systems.
Summary
A data lakehouse is intended to combine the benefits of data lakes (cost effective, scalable storage and compute) and data warehouses (user friendly SQL interface). Multiple open source projects and vendors have been working together to make this vision a reality. In this episode Dain Sundstrom, CTO of Starburst, explains how the combination of the Trino query engine and the Iceberg table format offer the ease of use and execution speed of data warehouses with the infinite storage and scalability of data lakes.
Announcements
- Hello and welcome to the Data Engineering Podcast, the show about modern data management
- Dagster offers a new approach to building and running data platforms and data pipelines. It is an open-source, cloud-native orchestrator for the whole development lifecycle, with integrated lineage and observability, a declarative programming model, and best-in-class testability. Your team can get up and running in minutes thanks to Dagster Cloud, an enterprise-class hosted solution that offers serverless and hybrid deployments, enhanced security, and on-demand ephemeral test deployments. Go to dataengineeringpodcast.com/dagster today to get started. Your first 30 days are free!
- Data lakes are notoriously complex. For data engineers who battle to build and scale high quality data workflows on the data lake, Starburst powers petabyte-scale SQL analytics fast, at a fraction of the cost of traditional methods, so that you can meet all your data needs ranging from AI to data applications to complete analytics. Trusted by teams of all sizes, including Comcast and Doordash, Starburst is a data lake analytics platform that delivers the adaptability and flexibility a lakehouse ecosystem promises. And Starburst does all of this on an open architecture with first-class support for Apache Iceberg, Delta Lake and Hudi, so you always maintain ownership of your data. Want to see Starburst in action? Go to dataengineeringpodcast.com/starburst and get $500 in credits to try Starburst Galaxy today, the easiest and fastest way to get started using Trino.
- Join in with the event for the global data community, Data Council Austin. From March 26th-28th 2024, they'll play host to hundreds of attendees, 100 top speakers, and dozens of startups that are advancing data science, engineering and AI. Data Council attendees are amazing founders, data scientists, lead engineers, CTOs, heads of data, investors and community organizers who are all working togethr to build the future of data. As a listener to the Data Engineering Podcast you can get a special discount of 20% off your ticket by using the promo code dataengpod20. Don't miss out on their only event this year! Visit: dataengineeringpodcast.com/data-council today.
- Your host is Tobias Macey and today I'm interviewing Dain Sundstrom about building a data lakehouse with Trino and Iceberg
Interview
- Introduction
- How did you get involved in the area of data management?
- To start, can you share your definition of what constitutes a "Data Lakehouse"?
- What are the technical/architectural/UX challenges that have hindered the progression of lakehouses?
- What are the notable advancements in recent months/years that make them a more viable platform choice?
- There are multiple tools and vendors that have adopted the "data lakehouse" terminology. What are the benefits offered by the combination of Trino and Iceberg?
- What are the key points of comparison for that combination in relation to other possible selections?
- What are the pain points that are still prevalent in lakehouse architectures as compared to warehouse or vertically integrated systems?
- What progress is being made (within or across the ecosystem) to address those sharp edges?
- For someone who is interested in building a data lakehouse with Trino and Iceberg, how does that influence their selection of other platform elements?
- What are the differences in terms of pipeline design/access and usage patterns when using a Trino/Iceberg lakehouse as compared to other popular warehouse/lakehouse structures?
- What are the most interesting, innovative, or unexpected ways that you have seen Trino lakehouses used?
- What are the most interesting, unexpected, or challenging lessons that you have learned while working on the data lakehouse ecosystem?
- When is a lakehouse the wrong choice?
- What do you have planned for the future of Trino/Starburst?
Contact Info
Parting Question
- From your perspective, what is the biggest gap in the tooling or technology for data management today?
Closing Announcements
- Thank you for listening! Don't forget to check out our other shows. Podcast.__init__ covers the Python language, its community, and the innovative ways it is being used. The Machine Learning Podcast helps you go from idea to production with machine learning.
- Visit the site to subscribe to the show, sign up for the mailing list, and read the show notes.
- If you've learned something or tried out a project from the show then tell us about it! Email hosts@dataengineeringpodcast.com) with your story.
Links
- Trino
- Starburst
- Presto
- JBoss
- Java EE
- HDFS
- S3
- GCS == Google Cloud Storage
- Hive
- Hive ACID
- Apache Ranger
- OPA == Open Policy Agent
- Oso
- AWS Lakeformation
- Tabular
- Iceberg
- Delta Lake
- Debezium
- Materialized View
- Clickhouse
- Druid
- Hudi
The intro and outro music is from The Hug by The Freak Fandango Orchestra / CC BY-SA
Sponsored By:
- Data Council:  Join us at the top event for the global data community, Data Council Austin. From March 26-28th 2024, we'll play host to hundreds of attendees, 100 top speakers and dozens of startups that are advancing data science, engineering and AI. Data Council attendees are amazing founders, data scientists, lead engineers, CTOs, heads of data, investors and community organizers who are all working together to build the future of data and sharing their insights and learnings through deeply technical talks. As a listener to the Data Engineering Podcast you can get a special discount off regular priced and late bird tickets by using the promo code dataengpod20. Don't miss out on our only event this year! Visit [dataengineeringpodcast.com/data-council](https://www.dataengineeringpodcast.com/data-council) and use code **dataengpod20** to register today! Promo Code: dataengpod20
- Starburst:  This episode is brought to you by Starburst - a data lake analytics platform for data engineers who are battling to build and scale high quality data pipelines on the data lake. Powered by Trino, Starburst runs petabyte-scale SQL analytics fast at a fraction of the cost of traditional methods, helping you meet all your data needs ranging from AI/ML workloads to data applications to complete analytics. Trusted by the teams at Comcast and Doordash, Starburst delivers the adaptability and flexibility a lakehouse ecosystem promises, while providing a single point of access for your data and all your data governance allowing you to discover, transform, govern, and secure all in one place. Starburst does all of this on an open architecture with first-class support for Apache Iceberg, Delta Lake and Hudi, so you always maintain ownership of your data. Want to see Starburst in action? Try Starburst Galaxy today, the easiest and fastest way to get started using Trino, and get $500 of credits free. [dataengineeringpodcast.com/starburst](https://www.dataengineeringpodcast.com/starburst)
- Dagster:  Data teams are tasked with helping organizations deliver on the premise of data, and with ML and AI maturing rapidly, expectations have never been this high. However data engineers are challenged by both technical complexity and organizational complexity, with heterogeneous technologies to adopt, multiple data disciplines converging, legacy systems to support, and costs to manage. Dagster is an open-source orchestration solution that helps data teams reign in this complexity and build data platforms that provide unparalleled observability, and testability, all while fostering collaboration across the enterprise. With enterprise-grade hosting on Dagster Cloud, you gain even more capabilities, adding cost management, security, and CI support to further boost your teams' productivity. Go to [dagster.io](https://dagster.io/lp/dagster-cloud-trial?source=data-eng-podcast) today to get your first 30 days free!
Remember Everything You Learn from Podcasts
