Microsoft Fabric: Time Travel in Data Warehouse for up to 30 Days!
Every wish you could see the changes in your Data Warehouse over time? Well Strap in because Bradley Ball, aka @SQLBalls , has got you covered! In this episode we look at a very troubled or busy (from a certain point of view), Employees table. We rebel against the current order and seek out the changes in our data, hoping one day to have peace throughout our Microsoft Fabric Data Warehouse. ...... also this is Star Wars themed. PLAY THE MUSIC!!
Chapters
00:00 Long Ago In a Data Warehouse Far Far Away
01:35 Demo Query Activity
02:45 Demo Get Granular Transaction Times
03:22 Demo Simple Time Travel Statements
04:09 Demo Time Travel with Dynamic SQL
04:56 Demo Time Travel Wrapped in a Stored Procedure
05:52 Demo Time Travel Parameterized Stored Procedure
06:51 Demo Time Travel & Order By
07:25 Demo Time Travel & the Where Clause
How to: Query using time travel at the statement level (preview)
https://learn.microsoft.com/en-us/fab...
Query data as it existed in the past
https://learn.microsoft.com/en-us/fab...
/*******************
/CONNECT WITH US!!
/*******************
Tales from the Field
Twitter/X: https://x.com/TalesftField
Linkedin: / 100091910
Bradley Ball
Twitter/X: https://x.com/SQLBalls
Linkedin: / sqlballs
Daniel Taylor
Twitter/X: https://x.com/dbabulldog
Linkedin: / danieltaylor3
Neeraj Jhaveri
Twitter/X: https://x.com/neeraj_jhaveri
Linkedin: / neerajjhaveri
Josh Luedeman
Twitter/X: https://x.com/joshluedeman
Linkedin: / joshluedeman
Andrés Padilla
Twitter/X: https://x.com/nodestreamio
Linkedin: / andrespadillaandrade
Bradley Schacht
Twitter/X: https://x.com/BradleySchacht
LinkedIn: / bradleyschacht
Marco Aurelio Cardoso
Twitter/X: https://x.com/macardoso95
LinkedIn: / marco-cardoso
Watch video Microsoft Fabric: Time Travel in Data Warehouse for up to 30 Days! online without registration, duration hours minute second in high quality. This video was added by user Tales From The Field 07 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 34 once and liked it 1 people.