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

Tämä jakso on lisätty Podme-palveluun avoimen RSS-syötteen kautta eikä se ole Podmen omaa tuotantoa. Siksi jakso saattaa sisältää mainontaa.

Jaksot(89)

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 ::  https://agiledata.substack.com/p/watch-now-recording-of-aura-tim-frazer-0d1   <-OO-> Listen to more podcasts on applying Agile Data patterns over at https://podcast.agiledata.io...

7 Elo 1h 2min

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

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

Raw and unedited https://agiledata.info/p/watch-now-recording-of-aura-tim-frazer-0d1?utm_source=youtube

6 Elo 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   <-OO-> Listen to more podcasts on applying Agile Data patterns over at https://podcast.agiledata.io/ Read more on th...

3 Elo 1h 1min

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

Watch 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

31 Heinä 1h 1min

Listen now | Recording of AURA - Anna Bergevin & Shane Gibson on 13th July 2026

Listen now | Recording of AURA - Anna Bergevin & Shane Gibson on 13th July 2026

Raw and unedited :: https://agiledata.info/p/watch-now-recording-of-aura-anna   <-OO-> Listen to more podcasts on applying Agile Data patterns over at https://podcast.agiledata.io/ Read more on th...

13 Heinä 1h

Listen now | Recording of AURA - Chris Gambill & Shane Gibson on 10th July 2026

Listen now | Recording of AURA - Chris Gambill & Shane Gibson on 10th July 2026

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

10 Heinä 1h 1min

Listen now | Recording of AURA - Tim Frazer & Shane Gibson on 1st July 2026

Listen now | Recording of AURA - Tim Frazer & Shane Gibson on 1st July 2026

Raw and unedited ::  https://agiledata.info/p/watch-now-recording-of-aura-tim-frazer   <-OO-> Listen to more podcasts on applying Agile Data patterns over at https://podcast.agiledata.io/ Read mor...

1 Heinä 1h 1min

The patterns of Focal Data Modeling and Identity Resolution with Patrik Lager

The patterns of Focal Data Modeling and Identity Resolution with Patrik Lager

In this episode of the Agile Data Podcast, where host Shane Gibson sits down with Patrik Lager, a data integration expert with 25 years of experience and a lead developer of the Focal framework. In th...

8 Touko 1h 4min