Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
dhorrall
Frequent Visitor

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

‎05-27-2023 05:38 AM

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

 

Labels:
Message 1 of 3
235 Views
0
1 ACCEPTED SOLUTION
ce87
Helper I
Helper I

‎05-27-2023 07:47 AM

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

Message 2 of 3
188 Views
0
2 REPLIES 2
dhorrall
Frequent Visitor

‎05-28-2023 07:38 AM

Using explicit query did work.

Message 3 of 3
162 Views
0
ce87
Helper I
Helper I

‎05-27-2023 07:47 AM

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.

Message 2 of 3
189 Views
0

Helpful resources

Announcements
November Fabric 2023 Webinars

Fabric Monthly Update - November 2023

Check out the November 2023 Fabric update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

View All