Data Engineering Podcast

What Happens When The Abstractions Leak On Your Data

Listen Later
Summary

All of the advancements in our technology is based around the principles of abstraction. These are valuable until they break down, which is an inevitable occurrence. In this episode the host Tobias Macey shares his reflections on recent experiences where the abstractions leaked and some observances on how to deal with that situation in a data platform architecture.

Announcements
  • Hello and welcome to the Data Engineering Podcast, the show about modern data management
  • RudderStack helps you build a customer data platform on your warehouse or data lake. Instead of trapping data in a black box, they enable you to easily collect customer data from the entire stack and build an identity graph on your warehouse, giving you full visibility and control. Their SDKs make event streaming from any app or website easy, and their extensive library of integrations enable you to automatically send data to hundreds of downstream tools. Sign up free at dataengineeringpodcast.com/rudderstack
  • Your host is Tobias Macey and today I'm sharing some thoughts and observances about abstractions and impedance mismatches from my experience building a data lakehouse with an ELT workflow
    • Interview
    • Introduction
    • impact of community tech debt
      • hive metastore
      • new work being done but not widely adopted
      • tensions between automation and correctness
      • data type mapping
        • integer types
        • complex types
        • naming things (keys/column names from APIs to databases)
        • disaggregated databases - pros and cons
          • flexibility and cost control
          • not as much tooling invested vs. Snowflake/BigQuery/Redshift
          • data modeling
            • dimensional modeling vs. answering today's questions
            • What are the most interesting, unexpected, or challenging lessons that you have learned while working on your data platform?
            • When is ELT the wrong choice?
            • What do you have planned for the future of your data platform?
              • Contact Info
              • LinkedIn
                • 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 [email protected]) with your story.
                  • To help other people find the show please leave a review on Apple Podcasts and tell your friends and co-workers
                    • Links
                    • dbt
                    • Airbyte
                      • Podcast Episode
                      • Dagster
                        • Podcast Episode
                        • Trino
                          • Podcast Episode
                          • ELT
                          • Data Lakehouse
                          • Snowflake
                          • BigQuery
                          • Redshift
                          • Technical Debt
                          • Hive Metastore
                          • AWS Glue

                            • The intro and outro music is from The Hug by The Freak Fandango Orchestra / CC BY-SA

                            Sponsored By:

                            • Rudderstack: ![Rudderstack](https://files.fireside.fm/file/fireside-uploads/images/c/c6161a3f-a67b-48ef-b087-52f1f1573292/CKNV8HZ6.png)
                            RudderStack provides all your customer data pipelines in one platform. You can collect, transform, and route data across your entire stack with its event streaming, ETL, and reverse ETL pipelines.
                            RudderStack’s warehouse-first approach means it does not store sensitive information, and it allows you to leverage your existing data warehouse/data lake infrastructure to build a single source of truth for every team.
                            RudderStack also supports real-time use cases. You can Implement RudderStack SDKs once, then automatically send events to your warehouse and 150+ business tools, and you’ll never have to worry about API changes again.
                            Visit [dataengineeringpodcast.com/rudderstack](https://www.dataengineeringpodcast.com/rudderstack) to sign up for free today, and snag a free T-Shirt just for being a Data Engineering Podcast listener.

                            Support Data Engineering Podcast

                            ...more
                            View all episodesView all episodes
                            Download on the App Store
                            Data Engineering PodcastBy Tobias Macey
                            • 4.5
                            • 4.5
                            • 4.5
                            • 4.5
                            • 4.5

                            4.5

                            142 ratings

                            More shows like Data Engineering Podcast

                            View all
                            This Week in Startups by Jason Calacanis

                            This Week in Startups

                            1,301 Listeners

                            The Changelog: Software Development, Open Source by Changelog Media

                            The Changelog: Software Development, Open Source

                            288 Listeners

                            The a16z Show by Andreessen Horowitz

                            The a16z Show

                            1,107 Listeners

                            Software Engineering Daily by Software Engineering Daily

                            Software Engineering Daily

                            630 Listeners

                            Risky Business by Risky Business Media

                            Risky Business

                            373 Listeners

                            Talk Python To Me by Michael Kennedy

                            Talk Python To Me

                            583 Listeners

                            Super Data Science: ML & AI Podcast with Jon Krohn by Jon Krohn

                            Super Data Science: ML & AI Podcast with Jon Krohn

                            308 Listeners

                            NVIDIA AI Podcast by NVIDIA

                            NVIDIA AI Podcast

                            347 Listeners

                            Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

                            Syntax - Tasty Web Development Treats

                            988 Listeners

                            Practical AI by Practical AI LLC

                            Practical AI

                            211 Listeners

                            Dwarkesh Podcast by Dwarkesh Patel

                            Dwarkesh Podcast

                            549 Listeners

                            The Data Engineering Show by The Firebolt Data Bros

                            The Data Engineering Show

                            9 Listeners

                            Latent Space: The AI Engineer Podcast by Latent.Space

                            Latent Space: The AI Engineer Podcast

                            104 Listeners

                            This Day in AI Podcast by Michael Sharkey, Chris Sharkey

                            This Day in AI Podcast

                            227 Listeners

                            The AI Daily Brief: Artificial Intelligence News and Analysis by Nathaniel Whittemore

                            The AI Daily Brief: Artificial Intelligence News and Analysis

                            683 Listeners