Fabric Table Clone error "Feature DISCOVERED TABLE is not supported"

[Kazanskyi]

I'm trying to clone a table as in the tutorial :

CREATE TABLE dbo.fact_invoice_hist_0621 AS CLONE OF dbo.fact_invoice

I get the error I can't find any documentation about:

Feature 'DISCOVERED TABLE' is not supported by table clone.

Msg 12510, Level 16, State 1, Code line 1

Does anyone know what it means?

[Kazanskyi · Accepted solution]

SQL endpoint doesn't have full functionality of the data warehouse in Fabric.
This function is relevant to the warehouse and for the lakehouse some PySpark is required.

[ushakrishna2k]

Hi,

I got this error when I tried to clone a table created in Lakehouse which is in delta format

I was able to clone tables that were created in a warehouse. the 'type' of the tables in warehouse is shown as 'User_table'..not sure what it means though.

when you click on the 3 dots next to these tables in warehouse you see an option to clone

But, in the lakehouse tables, ( in the sql endpoint) we dont have this option

[lbendlin]

Interesting. The official documentation Clone table - Microsoft Fabric | Microsoft Learn makes no note of "DISCOVERED TABLE".  Might be worth submitting feedback there or directly address with the product team. Table Clone in warehouse within Microsoft Fabric | Microsoft Fabric Blog | Microsoft Fabric