Episode 284: The Four-Letter Word ETL - Data Movement

Once you have your data stored in OneLake, you'll be ready to start transforming it to improve it's usability, accuracy, and efficiency. In this episode of the podcast, Belinda Allen takes us on a delightful journey through Data Flows, Power Query, Azure Data Factory (Pipelines), and discusses the merits of shortcuts. We also learn about a handy way to manually upload a table if you have some static data you need to update. There are many tools and techniques that can be used for data ingestion and transformations. And while some of these options we discuss will be up to individual preference, there are pros and cons to each. One of the blessings and curses of Fabric is that there are many ways of achieving the same result, so what you choose may depend on the nature of the data you have and your goals, but might also be dictated by personal experience. We hope you enjoyed this conversation with Belinda on ingesting and transforming data in Microsoft Fabric. If you have questions or comments, please send them our way. We would love to answer your questions on a future episode. Leave us a comment and some love ❤️on LinkedIn , X , Facebook , or Instagram . The show notes for today's episode can be found at Episode 284: The Four-Letter Word ETL - Data Movement . Have fun on the SQL Trail!

You can listen to Episode 284: The Four-Letter Word ETL - Data Movement online on Radio and Podcast. Open the player on this page to stream the available audio.

Episode 284: The Four-Letter Word ETL - Data Movement is an episode from SQL Data Partners Podcast by Marathon Consulting.

This episode is 58:57 long.

This episode was published on Feb 4, 2025.

Yes. Use the heart button on the episode page to add it to your favorite episodes list.

Yes. This page shows related episodes from SQL Data Partners Podcast when more episodes are available from the podcast feed.