Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Kazanskyi
Frequent Visitor

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?
 
 
1 ACCEPTED SOLUTION
Kazanskyi
Frequent Visitor

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.

View solution in original post

3 REPLIES 3
Kazanskyi
Frequent Visitor

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
New Member

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

ushakrishna2k_2-1719249616767.png

 

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

ushakrishna2k_1-1719249528095.png

 

lbendlin
Super User
Super User

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.