The Microsoft Fabric Pod (by Queryzens) podcast

02 - OneLake and Why Open Formats Matter - The Microsoft Fabric POD

0:00
2:30
Rewind 15 seconds
Fast Forward 15 seconds

Welcome back to Episode 2! Today, let's talk about the heart of Fabric: OneLake.

People often say OneLake is like "OneDrive for your data." It sounds a bit like an ad, but it’s actually the easiest way to picture it.

Think about how most offices work today:

• The sales team creates their own storage account.

• Finance has their own folder somewhere else.

• The engineering team has a third one.

Now, what happens if finance needs sales data to check company revenue? Someone has to sit and write a script to copy huge files from one team's storage to another.

It creates double the files and double the storage cost.

OneLake removes this headache. When your company turns on Fabric, you get just one single place for everything. Sales, finance, engineering—every workspace

sits inside this one big lake.

Now, how does this actually work without everything crashing?

Fabric uses an open file format called Delta-Parquet by default.

Here is why that matters:

• It keeps the files compressed so they don't take up too much space.

• It makes sure data doesn't get corrupted if two people use it at once.

• Most importantly, it is not a locked Microsoft-only format. It's open-source.

So, when your data engineer writes a table using Python or Spark, your SQL analyst can run a query on that exact same file immediately.

No one needs to export anything to an Excel sheet. No one needs to run a data copy job. It’s just one single file sitting on the disk, and everyone works on it directly.

In Episode 3, we'll see what you do if your company's data is already sitting in AWS or Google Cloud.


About the Host

Rajnish Pandey is a Senior Data Engineer with over decade of experience in the data industry. Through QueryZens, he shares practical insights, real-world experiences, and conversations around Data Engineering and modern data platforms.


Hosted by Rajnish Pandey | QueryZens

Making Data Engineering easier to understand, one conversation at a time.

More episodes from "The Microsoft Fabric Pod (by Queryzens)"