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

September 5, 2024 by Brad Watts

As part of the consumption model for Eventhouse, we are enabling Standard Storage consumption. This change is scheduled to start rolling out the week of September 16th. This means that you will start seeing billable consumption of the OneLake Storage Data Stored meter from the Eventhouse and KQL Database artifacts. For details on all things … Continue reading “Announcement: Eventhouse Standard Storage Billing”

August 28, 2024 by Adi Eldar

Anomaly Detector, one of Azure AI services, enables you to monitor and detect anomalies in your time series data. This service is based on advanced algorithms, SR-CNN for univariate analysis and MTAD-GAT for multivariate analysis and is being retired by October 2026. In this blog post we will lay out a migration strategy to Microsoft Fabric, allowing … Continue reading “Advanced Time Series Anomaly Detector in Fabric”