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

April 9, 2024 by Idris Motiwala

In the era of digital transformation, advanced analytics and an AI driven world, data has emerged as the new oil, powering businesses, and driving decision-making. But what good is this oil if it’s not refined and ready for use when needed? Moreover, managing, and ingesting data into a central platform for analytics and AI is … Continue reading “Announcing Mirroring Azure SQL Database in Fabric for Public Preview”

March 26, 2024 by Charles Webb

Mirroring is now available to customers in Public Preview. You can now seamlessly bring your databases into OneLake in Microsoft Fabric, enabling seamless zero-ETL, near real-time insights on your data – and unlocking warehousing, BI, AI, and more.