Agile Data N’ Info

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


Listen Later

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 | PodchaserDeezer | Podcast Addict




Buy the Green Book now!

 

Simply Magical Data Ways of Working

...more
View all episodesView all episodes
Download on the App Store

Agile Data N’ InfoBy AgileData


More shows like Agile Data N’ Info

View all
The Analytics Power Hour by Michael Helbling, Moe Kiss, Tim Wilson, Val Kroll, and Julie Hoyer

The Analytics Power Hour

167 Listeners

Americast by BBC News

Americast

722 Listeners