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

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!

Episoder(287)

Episode 255: Automate Complex CRUD with sp_CRUDGen

Episode 255: Automate Complex CRUD with sp_CRUDGen

One of the biggest challenges with developers using object-relational mapping (ORM) tools is the bad queries or procedures they create. Sure, most tools can create CRUD (Create, Read, Update, Delete, ...

5 Okt 202228min

Episode 254: Code Smell Checks with sp_Develop

Episode 254: Code Smell Checks with sp_Develop

Would you be interested in a tool to help you do code review checks and provide developers guidance on best practices? In this episode of the SQL Data Partners Podcast, we talk with Kevin Martin, the ...

21 Sep 202229min

Episode 253: Go Mobile with Power Apps

Episode 253: Go Mobile with Power Apps

In this episode, we dive into the Power Apps offering and discuss the pros and cons of using this latest Microsoft offering. Some definitions are given and hopefully this episode can orient folks on h...

7 Sep 202235min

Episode 252: The Cumulative Update Dilemma

Episode 252: The Cumulative Update Dilemma

Knowing your SQL Server is patched when an issue occurs is worth the effort of keeping it patched. While I don't suggest a zero-day install for most folks, setting up a regular cadence to check is a r...

24 Aug 202229min

Episode 251: Azure Cognitive Services

Episode 251: Azure Cognitive Services

How can you begin to integrate AI models into your environment without spending months building everything out? As we continue our march to Episode 256, we bring back our friend Sam Nasr to talk about...

10 Aug 202241min

Episode 250: What happens before... "COMPANEROS!"

Episode 250: What happens before... "COMPANEROS!"

This episode we are doing a bit of a look back and are going to air some previously buried content. Some of the bloopers are pre-video and some of them have some physical comedy, which you'll have to...

27 Jul 202219min

Episode 249: Data Marts in Power BI

Episode 249: Data Marts in Power BI

Data marts in Power BI have arrived and the words "data mart" mean something to data professionals. In this episode of the SQL Data Partners Podcast, we introduce the latest offering in Power BI and ...

13 Jul 202227min

Episode 248: Inventory Documentation

Episode 248: Inventory Documentation

How do you keep records of your SQL Server environments? Patching levels, security accounts, configuration options, maintenance jobs and the like are some of the pieces we have to keep organized. Ar...

29 Jun 20221h 1min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
foreldreradet
rss-strid-de-norske-borgerkrigene
treningspodden
jakt-og-fiskepodden
rss-sunn-okonomi
sinnsyn
mikkels-paskenotter
takk-og-lov-med-anine-kierulf
hverdagspsyken
gravid-uke-for-uke
rss-kunsten-a-leve
tomprat-med-gunnar-tjomlid
hagespiren-podcast
rss-bisarr-historie
rss-var-forste-kaffe
fryktlos
rss-kull