Forum Discussion

Kazanskyi's avatar
Kazanskyi
Icon for Helper I rankHelper I
2 years ago
Solved

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

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?
 
 
  • 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.

3 Replies

  • 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

     

  • 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.