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 (https://www.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 (https://www.linkedin.com/in/tmacey/)
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__ (https://www.pythonpodcast.com) covers the Python language, its community, and the innovative ways it is being used. The Machine Learning Podcast (https://www.themachinelearningpodcast.com) helps you go from idea to production with machine learning.
Visit the site (https://www.dataengineeringpodcast.com) 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 (mailto:hosts@dataengineeringpodcast.com)) with your story.
To help other people find the show please leave a review on Apple Podcasts (https://podcasts.apple.com/us/podcast/data-engineering-podcast/id1193040557) and tell your friends and co-workers
Links
dbt (https://www.getdbt.com/)
Airbyte (https://airbyte.com/)
Podcast Episode (https://www.dataengineeringpodcast.com/airbyte-open-source-data-integration-episode-173/)
Dagster (https://dagster.io/)
Podcast Episode (https://www.dataengineeringpodcast.com/dagster-software-defined-assets-data-orchestration-episode-309/)
Trino (https://trino.io/)
Podcast Episode (https://www.dataengineeringpodcast.com/presto-distributed-sql-episode-149/)
ELT (https://en.wikipedia.org/wiki/Extract,_load,_transform)
Data Lakehouse (https://www.forbes.com/sites/bernardmarr/2022/01/18/what-is-a-data-lakehouse-a-super-simple-explanation-for-anyone/?sh=5c0e333f6088)
Snowflake (https://www.snowflake.com/en/)
BigQuery (https://cloud.google.com/bigquery)
Redshift (https://aws.amazon.com/redshift/)
Technical Debt (https://en.wikipedia.org/wiki/Technical_debt)
Hive Metastore (https://cwiki.apache.org/confluence/display/Hive/AdminManual+Metastore+Administration)
AWS Glue (https://aws.amazon.com/glue/)
The intro and outro music is from The Hug (http://f