We have a specific statement to clone a table. But what exactly does it mean?
The Clone Table feature promises to create an image of the table on a specific point in time or with the current information. The documentation is not precise, because at some points it says it’s only a clone of the structure, but we can see the data on the table.
What’s the advantage of this over a simple SELECT INTO statement?
Read on for that comparison, as well as several other things recently added to Microsoft Fabric data warehouses.