Reverse ETL: Operationalizing Data Warehouses with Tejas Manohar

Enterprise data warehouses store all company data in a single place to be accessed, queried, and analyzed. They’re essential for business operations because they support managing data from multiple sources, providing context, and have built-in analytics tools. While keeping a single source of truth is important, easily moving data from the warehouse to other applications is invaluable.

The company Hightouch provides tools that easily move data from your warehouse to important business tools like Salesforce, Apache Airflow, Tableau and more. Hightouch uses SQL to move and transform your data and tracks every row to avoid moving data that hasn’t changed. Failed rows are retried, and all changes to rows are logged. 

In this episode, we talk to Tejas Manohar, Founder of Hightouch. We talk about reverse ETL, managing data across multiple systems, and how Hightouch helps companies operationalize their data warehouse.

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

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.

TeamCity Cloud is a new continuous integration service that is completely hosted and managed by JetBrains. It is based on the original on-premises version of TeamCity, and shares most of its functionality. Multiplatform development, integration with popular build and test frameworks, real-time feedback, test history and test analysis – these are just a few of the many powerful features that can take your team to a new level of productivity. You can try TeamCity Cloud free of charge for 14 days. The trial period gives you 12,000 build credits (equivalent of 20 build hours on the Linux Small build agent), unlimited parallel builds, 120 GB of storage, and up to 3 self-hosted build agents. Get started with cloud CI/CD today!

Act in Time with InfluxData. Developers using the InfluxDB platform build their applications with less effort, less code, and less configuration with the use of a set of powerful APIs and Tools. Easily write data into InfluxDB as well as query the stored data using its language-specific client libraries and quickly start monitoring your data using InfluxDB Templates, pre-made monitoring solutions that allow users to to create and share a comprehensive monitoring solution. For more information and to try it for free, visit influxdata.com/sedaily.

Today’s episode of Software Engineering Daily is sponsored by Datadog, a monitoring platform for cloud-scale infrastructure and applications. Datadog provides dashboarding, alerting, application performance monitoring, and log management in one tightly integrated platform so you can get end-to-end visibility quickly. And it integrates seamlessly with Google Cloud, so you can start monitoring Load Balancer, BigQuery, AppEngine, Kubernetes, and all your other Google Cloud services in minutes. Visualize key metrics, set alerts to identify anomalies, and collaborate with your team to troubleshoot and fix issues fast. Try it yourself by starting a free, 14-day trial today. Listeners of this podcast will also receive a free Datadog T-shirt! softwareengineeringdaily.com/datadog

For anyone who’s into tech or who uses tech — and that’s most of us — Season 2 of the New Reality Series by Arm Podcasts is here, and it’ll be exploring what the not-so-distant future of consumer technology will look like. Created by Arm — the leading provider of processor technology for mobile devices — this series looks 5–10 years into the future to see how digital and mobile technologies will further empower our lives. In episode one we meet Davis Fattal — co-founder and CEO of 3D lightfield tablet manufacturer, Leia – to talk about immersive engagement through mobile screen-based devices. Check out the New Reality Series by Arm Podcasts on Spotify, Apple, Google, Stitcher, or wherever you like to listen.

Software Weekly

Software Weekly

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