Solved: Legacy Synapse 'Serverless' Views not showing up a...

dhorrall · ‎05-27-2023

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?

ce87 · ‎05-27-2023

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

dhorrall · ‎05-28-2023

Using explicit query did work.

ce87 · ‎05-27-2023

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.