Problem Statement - Doing some hands-on with Azure Synapse Analytics (Workspace preview). Added a data flow to extract the data from data lake gen 2 account and transfer it into SQL pool. Get a error saying that managed service Identity is not enabled on this server.
Details - Here is how the source and sink for the data flow looks like
Source Dataset - Delimited Text
Sink Dataset - Azure Synapse Analytics (formerly SQL DW)
Previewing the data works fine both at the source and the sink level (after enabling data flow debug)
However, the pipeline/data flow errors out with the following details
Used managed identity while connecting to the azure data warehouse and looks like it is set up properly on the service
Connecting DWHoptions at the workspace level
I have tested the same pipeline via ADF service and everything runs smoothly there.
Thanks in advance