The Microsoft Fabric Pod (by Queryzens) podcast

03 - Shortcuts: Querying External Without Moving Files - The Microsoft Fabric POD

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

Welcome back to Episode 3! Today, let's tackle a question almost every team asks: What if our data is not in Microsoft Azure?

Let’s be honest—almost no company keeps everything in just one cloud.

You might have years of website logs stored in Amazon S3, or your digital marketing team might be saving all their click data in Google Cloud Storage.

Usually, if you want to use that data inside Azure, it’s a big headache:

• You have to build a pipeline to transfer the data.

• AWS or Google charges you network egress fees just to move the files out.

• You end up waiting hours for huge copy jobs to finish, creating even more duplicate files.

Fabric solves this with a feature called Shortcuts.

Think of a shortcut just like a desktop shortcut on your computer. The original file stays right where it is, but you can open and work on it from somewhere else.

In Fabric, you simply:

1. Open your workspace.

2. Enter your AWS or Google Cloud credentials.

3. Point directly to that external storage bucket.

That’s it. From that moment on, your Spark notebooks and SQL queries see that Amazon S3 folder just like a regular local folder inside Fabric.

The files never actually leave AWS or Google Cloud. You don’t have to wait for heavy data copy jobs, and you can write a single SQL query that joins an Azure

customer table directly with an Amazon S3 order table.

No moving files around, no duplicate storage bills.

In Episode 4, we’ll look at how compute power works in Fabric and how Microsoft bills you for running your queries.


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)"