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?
Go to Solution.
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
Using explicit query did work.
Check out the August 2023 Fabric update to learn about new features.
Become a founding member of the Data Factory Community.
Join Microsoft Reactor and learn from developers.