所需的 Blob 在预览复制数据活动的接收器数据集时丢失

huangapple go评论62阅读模式
英文:

Required Blob is missing when preview data of a copy data activity sink dataset

问题

我是Azure的新手。我创建了一个新的ADF、管道、存储blob帐户和复制数据活动,数据源来自SQL服务器表,而输出目标是一个parquet文件。但是当我预览我的目标数据集时,出现一个错误,说需要的blob文件丢失。

我还想创建一个目录,但无论我是手动输入文件夹名称和文件名,还是使用参数,我仍然收到错误。如果我通过Azure存储资源管理器手动上传文件,预览就不会出现问题。

有人知道我错过了什么吗?

谢谢帮助。

祝好
艾伯特

英文:

I am new to Azure. I created a new ADF, pipeline, storage blob account and a copy data activity, the source is from a SQL server table and the sink output is a parquet file. But when I preview the data of my sink dataset, I got an error saying the required blob is missing.

I want to create a directory as well but weather I type in the folder name and file name or using parameters, I still receive the error. If I manually upload a file via the Azure Storage Explorer, the preview will have no issue.

Anyone what I missed?

Thanks for the help.

cheers
Albert

答案1

得分: 1

I created linked service for Azure SQL database and blob storage account and created dataset of SQL database for source:

所需的 Blob 在预览复制数据活动的接收器数据集时丢失

Dataset of blob storage for sink:

所需的 Blob 在预览复制数据活动的接收器数据集时丢失

When I preview the data by entering file name I got below error:

所需的 Blob 在预览复制数据活动的接收器数据集时丢失

I got above error because I am not having that file in my blob storage. In data factory the file will create automatically while debug the pipeline without entering filename. I just gave the file path where my parquet file need save in sink dataset and debug the pipeline, it executed successfully.

所需的 Blob 在预览复制数据活动的接收器数据集时丢失

My SQL table is copied to blob storage as parquet file successfully.

所需的 Blob 在预览复制数据活动的接收器数据集时丢失

英文:

I created linked service for Azure SQL database and blob storage account and created dataset of SQL database for source:

所需的 Blob 在预览复制数据活动的接收器数据集时丢失

Dataset of blob storage for sink:

所需的 Blob 在预览复制数据活动的接收器数据集时丢失

When I preview the data by entering file name I got below error:

所需的 Blob 在预览复制数据活动的接收器数据集时丢失

I got above error because I am not having that file in my blob storage.
In data factory the file will create automatically while debug the pipeline without entering filename.
I just gave the file path where my parquet file need save in sink dataset and debug the pipeline, it executed successfully.

所需的 Blob 在预览复制数据活动的接收器数据集时丢失

My SQL table is copied to blob storage as parquet file successfully.

所需的 Blob 在预览复制数据活动的接收器数据集时丢失

huangapple
  • 本文由 发表于 2023年2月6日 10:00:58
  • 转载请务必保留本文链接:https://go.coder-hub.com/75356767.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定