英文:
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:
Dataset of blob storage for sink:
When I preview the data by entering file name I got below error:
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.
My SQL table is copied to blob storage as parquet file successfully.
英文:
I created linked service for Azure SQL database and blob storage account and created dataset of SQL database for source:
Dataset of blob storage for sink:
When I preview the data by entering file name I got below error:
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.
My SQL table is copied to blob storage as parquet file successfully.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论