Solved: Store less used Data for lower Costs

Poweraegg · ‎08-03-2023

Can we archive data/bring to cold tier to save costs in the future? Because the bigger the data lake becomes, the more the costs will rise, infinitely.

Anonymous · ‎08-03-2023

It's not possible in OneLake itself (at least not yet - you can share it as an idea: https://aka.ms/fabricideas).

Depending on your scenario, you could create an Azure Data Lake Storage Gen2 (ADLS Gen2) storage account in Azure and attach it to OneLake using shortcuts. Shortcuts to ADLS Gen2 work both ways (read and write) so you could dump data for archive to the ADLS Gen2 and then use access tiers of ADLS Gen2 to optimize the cost of storage.

NOTE: It's best to have your ADLS Ge2 in the same Azure region as your Microsoft Fabric tenant (Find your Fabric home region - Microsoft Fabric | Microsoft Learn) to avoid inter region data transfer charges.

View solution in original post

Anonymous · ‎08-03-2023

It's not possible in OneLake itself (at least not yet - you can share it as an idea: https://aka.ms/fabricideas).

Depending on your scenario, you could create an Azure Data Lake Storage Gen2 (ADLS Gen2) storage account in Azure and attach it to OneLake using shortcuts. Shortcuts to ADLS Gen2 work both ways (read and write) so you could dump data for archive to the ADLS Gen2 and then use access tiers of ADLS Gen2 to optimize the cost of storage.

NOTE: It's best to have your ADLS Ge2 in the same Azure region as your Microsoft Fabric tenant (Find your Fabric home region - Microsoft Fabric | Microsoft Learn) to avoid inter region data transfer charges.