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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
dhorrall
Helper I
Helper I

Legacy Synapse 'Serverless' Views not showing up as source tables in 'Copy Activity?

I am trying to do a simple test of moving data currently in a 'serverless' Synapse View to a LakeHouse.  No source views show up to choose from.  Is this a bug?

dhorrall_0-1685191032900.png

 

1 ACCEPTED SOLUTION
ce87
Helper I
Helper I

I believe the copy activity only supports tables, which I believe is the case currently in synapse as well (although happy to be proved wrong on that, been a while since I've used the copy tool).

 

You could choose "Use Query" instead and do a SELECT * FROM view_name.

View solution in original post

2 REPLIES 2
dhorrall
Helper I
Helper I

Using explicit query did work.

ce87
Helper I
Helper I

I believe the copy activity only supports tables, which I believe is the case currently in synapse as well (although happy to be proved wrong on that, been a while since I've used the copy tool).

 

You could choose "Use Query" instead and do a SELECT * FROM view_name.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

March 2024 FBC Gallery Image

Fabric Monthly Update - March 2024

Check out the March 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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