Azure-Samples / Azure-Samples/Synapse

Dataflow - Writing to Dedicated pool giving error when staging is enabled

Open
#173 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Jupyter Notebook
Stars
387
Forks
344
PR merge metrics
No merged PRs in 30d

Description

When Writing data from ADLS Gen2 or Blob storage to Dedicated Synapse pool in ADF Dataflow, it is giving the below error.

![](https://i.imgur.com/g4Qfnw7.png)

But it got resolved when the staging in the sink was disabled.

![](https://i.imgur.com/LOhpw3N.png)

It is giving the same result even though tried for multiple times. It was not mentioned in any documentation that staging should be disabled in this scenario. Staging is very important for the performance in large data, so Is this a bug?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.