Union two or more tables together automatically, AgileData Engineering Pattern #2 - Episode #68

EPISODE · Jul 3, 2025 · 10 MIN

Union two or more tables together automatically, AgileData Engineering Pattern #2 - Episode #68

from Agile Data N’ Info · host AgileData

Join Shane Gibson and Nigel Vining as they describe and discuss the AgileData Engineering Pattern of Unioning two or more tables together automatically.   The Automated Table Unioning pattern automatically combines two or more tables by intelligently looking up column names and data types to generate safe SQL under the covers. It supports disparate data sources, such as those from multiple publishers in a data clean room, and creates a view or incrementally loads the unified data into a physical table while tracking load watermarks to prevent duplicates.   An AgileData Engineering Pattern is a repeatable, proven approach for solving a common data engineering challenge in a simple, consistent, and scalable way, designed to reduce rework, speed up delivery, and embed quality by default.     If you just want to talk about making magic happen with agile and data you can connect with Shane @shagility on LinkedIn.   Subscribe: Apple Podcast | Spotify | Google Podcast  | Amazon Audible | TuneIn | iHeartRadio | PlayerFM | Listen Notes | Podchaser |  Deezer | Podcast Addict |  Buy the Green Book now!   Simply Magical Data Ways of Working

NOW PLAYING

Union two or more tables together automatically, AgileData Engineering Pattern #2 - Episode #68

0:00 10:32

No transcript for this episode yet

We transcribe on demand. Request one and we'll notify you when it's ready — usually under 10 minutes.

No similar episodes found.

The Data Engineering Show The Firebolt Data Bros The Data Engineering Show is a podcast for data engineering and BI practitioners to go beyond theory. Learn from the biggest influencers in tech about their practical day-to-day data challenges and solutions in a casual and fun setting.SEASON 1 DATA BROSEldad and Boaz Farkash shared the same stuffed toys growing up as well as a big passion for data. After founding Sisense and building it to become a high-growth analytics unicorn, they moved on to their next venture, Firebolt, a leading high-performance cloud data warehouse.SEASON 2 DATA BROSIn season 2 Eldad adopted a brilliant new little brother, and with their shared love for query processing, the connection was immediate. After excelling in his MS, Computer Science degree, Benjamin Wagner joined Firebolt to lead its query processing team and is a rising star in the data space. For inquiries contact [email protected]: https://www.firebolt.io fuzz – Swamp Jacuzzi Biggie Boutte An intoxicating wild mind trip through the past, present, and future realms of rock n roll. A euphoric cocktail of spiritual awakening through fuzz and focal points. A new dawn taking the past into the future and the future towards comforts unknown. A yesterday's tomorrow. That time is now. So free your soul and expand your mind. The key to the gates is through this sonic elixir. Administer the medicine, fasten your seatbelts and hold on tight. We have a long journey ahead. But if you want to rock it, you know it's in the pocket. You need Electrophonic Tonic. It could save your soul. Ya dig? AI Daily News Podcast Really Easy AI AI Daily News: Your premier source for cutting-edge artificial intelligence updates! Dive into the world of machine learning, deep learning, and data science with our daily tech briefings. From neural networks to natural language processing, we cover groundbreaking AI research, innovative applications, and industry trends. Explore the latest in computer vision, robotics, autonomous systems, and the Internet of Things. Stay informed on AI ethics, machine learning algorithms, and the transformative impact of AI on business, healthcare, and society. https://www.youtube.com/@AINewsFresh Gytis Tech Podcast Inretio Data professional and tech enthusiast from Lithuania, covering tech topics including open source software, smart home automation, web development, automotive diagnostics and more.
URL copied to clipboard!