Build Your Data Transformations Faster And Safer With SDF

OCT 6, 202442 MIN
Data Engineering Podcast

Build Your Data Transformations Faster And Safer With SDF

OCT 6, 202442 MIN

Description

Summary<br />In this episode of the Data Engineering Podcast Lukas Schulte, co-founder and CEO of SDF, explores the development and capabilities of this fast and expressive SQL transformation tool. From its origins as a solution for addressing data privacy, governance, and quality concerns in modern data management, to its unique features like static analysis and type correctness, Lucas dives into what sets SDF apart from other tools like DBT and SQL Mesh. Tune in for insights on building a business around a developer tool, the importance of community and user experience in the data engineering ecosystem, and plans for future development, including supporting Python models and enhancing execution capabilities.<br />Announcements<br /><ul><li>Hello and welcome to the Data Engineering Podcast, the show about modern data management</li><li>Imagine catching data issues before they snowball into bigger problems. That’s what Datafold’s new Monitors do. With automatic monitoring for cross-database data diffs, schema changes, key metrics, and custom data tests, you can catch discrepancies and anomalies in real time, right at the source. Whether it’s maintaining data integrity or preventing costly mistakes, Datafold Monitors give you the visibility and control you need to keep your entire data stack running smoothly. Want to stop issues before they hit production? Learn more at <a href="https://www.dataengineeringpodcast.com/datafold" target="_blank">dataengineeringpodcast.com/datafold</a> today!</li><li>Your host is Tobias Macey and today I'm interviewing Lukas Schulte about SDF, a fast and expressive SQL transformation tool that understands your schema</li></ul>Interview<br /><ul><li>Introduction</li><li>How did you get involved in the area of data management?</li><li>Can you describe what SDF is and the story behind it?<ul><li>What's the story behind the name?</li></ul></li><li>What problem are you solving with SDF?<ul><li>dbt has been the dominant player for SQL-based transformations for several years, with other notable competition in the form of SQLMesh. Can you give an overview of the venn diagram for features and functionality across SDF, dbt and SQLMesh?</li></ul></li><li>Can you describe the design and implementation of SDF?<ul><li>How have the scope and goals of the project changed since you first started working on it?</li></ul></li><li>What does the development experience look like for a team working with SDF?<ul><li>How does that differ between the open and paid versions of the product?</li></ul></li><li>What are the features and functionality that SDF offers to address intra- and inter-team collaboration?</li><li>One of the challenges for any second-mover technology with an established competitor is the adoption/migration path for teams who have already invested in the incumbent (dbt in this case). How are you addressing that barrier for SDF?<ul><li>Beyond the core migration path of the direct functionality of the incumbent product is the amount of tooling and communal knowledge that grows up around that product. How are you thinking about that aspect of the current landscape?</li></ul></li><li>What is your governing principle for what capabilities are in the open core and which go in the paid product?</li><li>What are the most interesting, innovative, or unexpected ways that you have seen SDF used?</li><li>What are the most interesting, unexpected, or challenging lessons that you have learned while working on SDF?</li><li>When is SDF the wrong choice?</li><li>What do you have planned for the future of SDF?</li></ul>Contact Info<br /><ul><li><a href="https://www.linkedin.com/in/lukas-schulte-a6b16254/" target="_blank">LinkedIn</a></li></ul>Parting Question<br /><ul><li>From your perspective, what is the biggest gap in the tooling or technology for data management today?</li></ul>Links<br /><ul><li><a href="https://www.sdf.com/" target="_blank">SDF</a></li><li><a href="https://www.datacamp.com/blog/semantic-layer" target="_blank">Semantic Data Warehouse</a></li><li><a href="https://asdf-vm.com/" target="_blank">asdf-vm</a></li><li><a href="https://www.getdbt.com/" target="_blank">dbt</a></li><li><a href="https://en.wikipedia.org/wiki/Lint_(software" target="_blank">Software Linting</a>)</li><li><a href="https://sqlmesh.readthedocs.io/en/stable/" target="_blank">SQLMesh</a><ul><li><a href="https://www.dataengineeringpodcast.com/sqlmesh-open-source-dataops-episode-380" target="_blank">Podcast Episode</a></li></ul></li><li><a href="https://coalesce.io/" target="_blank">Coalesce</a><ul><li><a href="https://www.dataengineeringpodcast.com/coalesce-enterprise-analytics-transformations-episode-278" target="_blank">Podcast Episode</a></li></ul></li><li><a href="https://iceberg.apache.org/" target="_blank">Apache Iceberg</a><ul><li><a href="https://www.dataengineeringpodcast.com/iceberg-with-ryan-blue-episode-52/" target="_blank">Podcast Episode</a></li></ul></li><li><a href="https://duckdb.org/" target="_blank">DuckDB</a>&nbsp;<ul><li><a href="https://www.dataengineeringpodcast.com/duckdb-in-process-olap-database-episode-270/" target="_blank">Podcast Episode</a>&nbsp;</li></ul></li><li><a href="https://docs.sdf.com/guide/basics/classifiers" target="_blank">SDF Classifiers</a></li><li><a href="https://docs.getdbt.com/docs/build/semantic-models" target="_blank">dbt Semantic Layer</a></li><li><a href="https://hub.getdbt.com/calogica/dbt_expectations/latest/" target="_blank">dbt expectations</a></li><li><a href="https://datafusion.apache.org/" target="_blank">Apache Datafusion</a></li><li><a href="https://ibis-project.org/" target="_blank">Ibis</a></li></ul>The intro and outro music is from <a href="http://freemusicarchive.org/music/The_Freak_Fandango_Orchestra/Love_death_and_a_drunken_monkey/04_-_The_Hug" target="_blank">The Hug</a> by <a href="http://freemusicarchive.org/music/The_Freak_Fandango_Orchestra/" target="_blank">The Freak Fandango Orchestra</a> / <a href="http://creativecommons.org/licenses/by-sa/3.0/" target="_blank">CC BY-SA</a>