topic Re: Legacy Synapse 'Serverless' Views not showing up as source tables in 'Copy Activity? in Pipelines

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

dhorrall — Fri, 09 Jun 2023 03:01:55 GMT

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?

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

Anonymous — Sat, 27 May 2023 14:47:40 GMT

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.

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

dhorrall — Sun, 28 May 2023 14:38:25 GMT

Using explicit query did work.