Microsoft Fabric Updates Blog

Reduce egress costs with S3 shortcuts in OneLake

Fabric allows workloads to easily access data across clouds through OneLake shortcuts. Define a shortcut once and use it with Power BI reports, SQL, Spark and Kusto. This ease of consumption allows users to start analyzing their data in minutes rather than hours or even days, but this can also lead to increased egress charges.

Cloud providers like Azure, AWS and GCP have extra networking fees when the data goes out of their infrastructure. The fees are usually measured in cents per gigabyte and look minor on the pricing guides, but they can become significant in the context of big data analytics. For this reason, we are happy to announce that OneLake shortcuts to S3 now has caching functionality.

A diagram of a cloud computing system

Description automatically generated

With caching for S3 shortcuts, egress costs are greatly reduced. As files are read through an S3 shortcut, the files are stored in a cache for the Fabric workspace. Subsequent read requests are served from cache rather than S3 directly. Cached files have a retention period of 24 hours. Each time the file is accessed the retention period is reset. If the file in S3 is more recent than the file in the cache, the request is served from S3 and the updated file will be stored in cache. If a file hasn’t been accessed for more than 24hrs it is purged from the cache.

A diagram of a project

Description automatically generated

How to enable caching for S3 shortcut:

Cache for S3 shortcuts is enabled at a workspace level. Workspace admins can start by opening a Fabric workspace and selecting “Workspace settings

In the workspace settings panel, select the “OneLake” tab. Switch the toggle for “Enable Cache for S3 Shortcuts” to “On”. Then click the “Save” button.

A screenshot of a computer

Description automatically generated

Caching is now enabled for all S3 shortcuts in that workspace. Any existing or new S3 shortcut will utilize the cache.

For a reminder on creating S3 shortcuts, follow our guide here: Create an Amazon S3 shortcut – Microsoft Fabric | Microsoft Learn

Related blog posts

Reduce egress costs with S3 shortcuts in OneLake

July 24, 2024 by Jason Himmelstein

Welcome to the July 2024 update. Here are a few, select highlights of the many we have for Fabric. Creating and managing Git branches & connected workspaces with Git integration just got with the latest enhancements to Fabric Git integration. You now have the capability to perform restore-in-place of a warehouse in Microsoft Fabric through … Continue reading “Microsoft Fabric July 2024 Update”

July 16, 2024 by Miquella de Boer

This guide will show you how to create a OneLake shortcut to a VPC-protected Amazon S3 bucket. Why use the On-premises-data gateway? Today, organizations are protecting data by leveraging network security capabilities like virtual networks, firewalls and virtual protected clouds (VPC). To access data securely and to provide a bridge between protected environments and Microsoft … Continue reading “Creating a shortcut to a VPC-protected Amazon S3 bucket”