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

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

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

Det här avsnittet är hämtat från ett öppet RSS-flöde och publiceras inte av Podme. Det kan innehålla reklam.

Avsnitt(93)

Listen now | Recording of AURA - Anna Bergevin & Shane Gibson 21st September 2026

Listen now | Recording of AURA - Anna Bergevin & Shane Gibson 21st September 2026

Raw and unedited   Top 3 things: Personal OS / “Watson OS” a privacy-conscious household management system that filters emails, checks shared calendars, routes responsibilities, and sends daily/week...

21 Sep 56min

Listen Now | Recording of AURA - Chris Gambill & Shane Gibson on 11th September 2026

Listen Now | Recording of AURA - Chris Gambill & Shane Gibson on 11th September 2026

Raw and unedited Top 3 things: How to migrate legacy data platforms safely audit first, choose greenfield vs. lift-and-shift early, define the target architecture, and validate with a thin-slice POC...

11 Sep 1h 6min

Listen now | Recording of AURA - Tim Frazer & Shane Gibson on 2nd September 2026

Listen now | Recording of AURA - Tim Frazer & Shane Gibson on 2nd September 2026

Raw and unedited Top 3 things: Data platform architecture and orchestration whether agent meshes can replace traditional DAG-based orchestration, and when platform-native tools are sufficient. Cho...

4 Sep 1h 4min

Listen now | Recording of AURA - Juha Korpela & Shane Gibson on 28 August 2026

Listen now | Recording of AURA - Juha Korpela & Shane Gibson on 28 August 2026

Raw and unedited   https://agiledata.info/p/watch-now-recording-of-aura-juha-a97?utm_source=youtube   <-OO-> Information Product Canvas Workshop “That’s not what I wanted.” “But that’s what you ask...

28 Aug 1h

Listen now | Recording of AURA - Anna Bergevin & Shane Gibson on 21st August 2026

Listen now | Recording of AURA - Anna Bergevin & Shane Gibson on 21st August 2026

Raw and unedited   https://agiledata.info/p/watch-now-recording-of-aura-anna-ad5?utm_source=youtube   <-OO-> Information Product Canvas Workshop “That’s not what I wanted.” “But that’s what you ask...

21 Aug 1h 7min

Listen now | Recording of AURA - Chris Gambill & Shane Gibson on 14th August 2026

Listen now | Recording of AURA - Chris Gambill & Shane Gibson on 14th August 2026

Raw and unedited   https://agiledata.info/p/watch-now-recording-of-aura-chris-0ce?utm_source=youtube   <-OO-> Listen to more podcasts on applying Agile Data patterns over at https://podcast.agiledata....

14 Aug 55min

Listen now | Recording of AURA - Tim Frazer & Shane Gibson on 5th August 2026

Listen now | Recording of AURA - Tim Frazer & Shane Gibson on 5th August 2026

Raw and unedited Top 3 things: Architecture and tests matter more than code generation. AI can build quickly, but sustainable work depends on clear outcomes, strong test coverage, and system-level ...

5 Aug 1h 2min

Listen now | Recording of AURA - Juha Korpela & Shane Gibson on 31st July 2026

Listen now | Recording of AURA - Juha Korpela & Shane Gibson on 31st July 2026

Raw and unedited   https://agiledata.info/p/watch-now-recording-of-aura-juha?utm_source=youtube     <-OO-> Listen to more podcasts on applying Agile Data patterns over at https://podcast.agiledata.i...

31 Juli 1h 1min

Populärt inom Teknik

uppgang-och-fall
natets-morka-sida
elbilsveckan
bilar-med-sladd
skogsforum-podcast
rss-en-ai-till-kaffet
rss-elektrikerpodden
rss-laddstationen-med-elbilen-i-sverige
market-makers
rss-technokratin
rss-veckans-ai
rss-sakerhetspodcasten
developers-mer-an-bara-kod
rss-ai-med-jonas-benjamin
bli-saker-podden
rss-uppgang-och-fall
rss-fabriken-2
rss-powerboat-sverige-podcast
rss-en-liten-podd-om-it
rss-snacka-om-ai