Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,510 questions
Error copying data from Amazom S3 into Azure Tables
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 99%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mnh Samba
1
Reputation point
Hello there This is the first time I am trying Data Factory. I am trying to copy data from AWS S3 bucket into an Azure Table Storage but I keep getting this error, any assistance would be highly appreciated:
![78226-image.png][1]
[1]: /api/attachments/78226-image.png?platform=QnA Thanks in advance.
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,637 Reputation points Microsoft Employee Moderator2021-03-17T00:50:06.877+00:00 Hi @Mnh Samba ,
Welcome to Microsoft Q&A forum and thanks for reaching out.
Could you please share the failed pipeline runId and failed activity runID? And also please do confirm what is the Integration runtime being used on both source as well as sink?We look forward to your response.
Thanks
-
Mnh Samba 1 Reputation point
2021-03-17T03:04:29.167+00:00 Hi Kranthi
Thank you for your reponse.
The Pipeline runID: f10b6789-f1b5-4eb3-98f2-68ea91e018ae
Activity runID: 1af846ed-e300-48d7-b11e-d7843d199f2bIntegratin Runtime: AutoResolveIntegrationRuntime
Thanks
-
KranthiPakala-MSFT 46,637 Reputation points Microsoft Employee Moderator
2021-03-17T22:37:24.793+00:00 Thanks for your response and details @Mnh Samba . As per the initial analysis, it seems to be an issue with the sink dataset (Azure Table Storage) configuration. Could you please share a screenshot of your sink settings? Suspecting something wrong with
Partition KeyorRow Key
Also I would recommend to review the
Property NamesandProperty Limitationssection of this doc: Understanding the Table service data model and let us know how it goesThanks
-
KranthiPakala-MSFT 46,637 Reputation points Microsoft Employee Moderator
2021-03-18T19:48:26.603+00:00 Hi @Mnh Samba ,
Just checking to see if you have got a chance to see my previous comment and review your sink settings as per the given document?
Do let us know how it goes.
Thanks
-
KranthiPakala-MSFT 46,637 Reputation points Microsoft Employee Moderator
2021-03-19T17:56:11.81+00:00 Hi @Mnh Samba ,
We still have not heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue. Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
Thanks
-
Mnh Samba 1 Reputation point
2021-03-21T21:52:42.737+00:00 Hello @KranthiPakala-MSFT
Sorry about the delay in responding.
Heres a screenshot of the sink settings:
-
KranthiPakala-MSFT 46,637 Reputation points Microsoft Employee Moderator
2021-03-30T00:44:33.753+00:00 Hi @Mnh Samba ,
Sorry for the delay in response. Looks like you have the default settings. I tried to reproduce the issue but no luck. In case if you are still facing the issue, I would recommend to file a support ticket for deeper investigation. If you don't have a support plan please let us know here.
Thanks
-
KranthiPakala-MSFT 46,637 Reputation points Microsoft Employee Moderator
2021-03-30T19:01:56.547+00:00 Hi @Mnh Samba ,
Just checking to see if you have got a chance to file a support ticket? If you don't have a support plan, do let us know. Incase if you have already found a solution, please do share it here with community.
Thanks
Sign in to comment
Sign in to answer