DBT: Data Build Tool with Tristan Handy

Applications write data to persistent storage like a database.  The most popular database query language is SQL which has many similar dialects.  SQL is expressive and powerful for describing what data you want.  What you do with that data requires a solution in the form of a data pipeline.  Ideally, these analytical workflows can follow similar best practices to those handled in application code.

DBT is a transformation workflow that lets teams deploy analytics code following software engineering best practices like modularity, portability, CI/CD, and documentation. Users who know SQL can build production-grade data pipelines.  In this episode, I interview Tristan Handy, CEO, and founder of DBT Labs.

Sponsorship inquiries: sponsor@softwareengineeringdaily.com

Transcript

Transcript provided by We Edit Podcasts. Software Engineering Daily listeners can go to weeditpodcasts.com to get 15% off the first three months of audio editing and transcription services with code: SED. Thanks to We Edit Podcasts for partnering with SE Daily. Please click here to view this show’s transcript.


Sponsors

Your project management tool should be a breeze to setup, at least mildly enjoyable to use, and help evolve your already existing development workflows so it’s easier to get things done. Does that describe your current tool? If it does, great! You can stop reading. If not, then Shortcut (formerly known as Clubhouse) could be the perfect fit. We’re project management built specifically for software teams and we’re fast, intuitive, flexible, powerful, and many other nice, positive adjectives. Delight the grumpiest scrum masters with Shortcut. Give it a try at softwareengineeringdaily.com/shortcut and get two months free.

Today’s episode of Software Engineering Daily is sponsored by DevOps Loop at VMworld. DevOps in the age of Kubernetes is about more than shiny bells and whistles. It’s also about building on the skills you already have. And that’s exactly what’s on tap at this year’s DevOps Loop at VMworld, October 4th. Join your friends from the community for a full day of talks focused on how to apply core DevOps principles in the world of modern apps, multi-cloud, and Kubernetes. It’s all online, it doesn’t cost a thing, and it won’t be the same without you. See the full agenda and speaker lineup for yourself at softwareengineeringdaily.com/devopsloop.

G2i is the only marketplace just for pre-vetted JavaScript developers. Hire React, React Native, & Node.js developers you can trust on a contract or full-time basis. G2i will match you with pre-vetted developers within three days of your onboarding call. You’ll be able to review their technical profiles and set up interviews with candidates you like. You get a detailed technical profile that provides the developer’s assessment scores in each category, a copy of their code challenge, and a recording of their technical interview. Test a working relationship with no risk! The first week is free if you decide your developer isn’t a good fit. G2i’s litmus test is simple: can this developer make an impact in your codebase within their first week? Go to softwareengineeringdaily.com/g2i to get started.

Spot by NetApp is the cloud automation platform that makes it easy to deliver continuously optimized infrastructure at the lowest possible cost. Spot helps their customers get the most out of their cloud investments by automating cloud infrastructure to ensure performance, reduce complexity, and optimize costs. Discover how leading companies, from cloud-native startups to global enterprises, are automating, simplifying, and optimizing their cloud infrastructure with Spot by NetApp. Check them out at Spot.io/SEDAILY where you can find more information, request a demo, or even start a free trial.

Are you ready to build innovative apps and accelerate your app dev career? You’re invited to join the global community of developers at the virtual OutSystems Developer Conference to learn, connect, and build the future of software development. OSDC is a conference on November 17-18 by developers, for developers and focuses exclusively on what you want to learn. Plus, this will be the biggest OutSystems developer conference yet with more than 50 sessions and 5+ tracks. Make sure you register today. Plus, the event is 100% virtual and 100% free! Visit outsystems.com/sedaily to learn more about the event and claim your free ticket. Hope to see you there!

Software Weekly

Software Weekly

Subscribe to Software Weekly, a curated weekly newsletter featuring the best and newest from the software engineering community.