从Azure Data Factory中的多个表构建单个数据集 [英] Build single dataset from multiple tables in Azure Data Factory

问题描述

我有一个要求，要求我使用数据存储中查询中的视图.内置的复制实用程序似乎不喜欢带有内部联接的查询.我知道查询有效，因为我在本地SSIS中对其进行了测试.如何在ADF中建立连接2个或更多表的数据集?我尝试转到高级选项卡，并在查询中引用SqlDataReader，但无法弄清楚如何查看结果预览.请协助.

I have an ask which requires me to use views in the query from the data store. The built-in copy utility doesn't seem to like my query with inner joins. I know the query works because I tested it in my local SSIS. How can I build a dataset that joins 2 or more tables in ADF? I tried going to the advanced tab and referencing SqlDataReader with my query, but I can't figure out how to see a preview of the results. Please assist.

推荐答案

抱歉，回复晚.希望您已经知道如何执行此操作.创作UI已更新，您现在不需要使用高级"选项卡.转到复制活动源选项卡，将查询放入查询输入框，然后按预览"按钮，您将看到查询结果.

Sorry for the late response. Hope you have figured out how to do this. The authoring UI has been updated and you don't need to use Advanced tab now. Go to the copy activity source tab, put your query in the query input box, and then press the Preview button, you will see the query results.

这篇关于从Azure Data Factory中的多个表构建单个数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！