Microsoft Fabric Updates Blog

Time-Travelling through data: The Magic of Table clones

On July 5th, we announced the ability to clone data warehouse tables within Microsoft Fabric as of current point in time. The ability to clone tables is a powerful technique that not only empowers businesses to streamline reporting and analytics but also helps expedite development and testing processes. 

While data warehouses constantly evolve, it is often necessary to capture a snapshot of data as it existed at a particular moment in time. We are now excited to introduce the ability to clone tables with time travel, up to a default data history retention period of seven calendar days. Table clones can be created within and across schemas in the data warehouse within Microsoft Fabric. 

Businesses can now unlock the ability to perform historical trend analysis, enabling them to compare data from various historical points. It empowers them to identify trends and facilitates making well-informed, data-driven decisions. 

Cloning a table at previous time points offers the advantage of preserving historical data records, serving a valuable role in meeting various audit and compliance requirements. When data discrepancies occur, these clones not only assist in generating older table versions for root cause analysis but also help create older versions of the table for seamless business continuity. 

We are also excited to offer you an intuitive user experience (UX) to clone tables enabling you to choose and clone multiple tables at once.

Screenshot showing the entry point for clone table context menu.

The Power of Choice

Whether you gravitate towards the experience through T-SQL or embrace the simplicity of UX, both methods cater to the needs of technical experts, citizen developers and analysts. The ability to create table clones in Synapse data warehouse within Microsoft Fabric significantly boosts the convenience and efficiency of data recovery and analysis like never before.

Get started with time travel by creating your clone either through T-SQL or through UX in the Microsoft Fabric portal. 

Related blog posts

Time-Travelling through data: The Magic of Table clones

November 15, 2023 by Bogdan Crivat

Earlier this year, at Microsoft Build, we introduced, in Public Preview, Microsoft Fabric, “the biggest data product announcement since SQL Server”. Today, we are announcing the General Availability of Microsoft Fabric. Arun explains in detail why we all believe Microsoft Fabric will redefine the current analytics landscape. I will focus here on what it means … Continue reading “Microsoft Fabric, explained for existing Synapse users”

November 15, 2023 by Ryan Majidimehr

Welcome to the November 2023 update.   We have lots of features this month including Narrative visual with Copilot, cross workspace “save as” for Data Factory, the general availability of Semantic model scale-out, and many more. Continue reading for more details on our new features!    Contents Core Microsoft Fabric User API Power BI Reporting Button … Continue reading “Microsoft Fabric November 2023 update”