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
Смотрите видео Microsoft Fabric: Time Travel in Data Warehouse for up to 30 Days! онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Tales From The Field 07 Август 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 34 раз и оно понравилось 1 людям.