从blob存储中加载与特定字符串模式匹配的所有文件 [英] load all files from blob storage matching a specific string pattern

问题描述

大家好，

在我的情况下寻找你的建议。

我正在处理具有不同名称的JSON文件。因此，我的管道应该能够处理BLOB存储上特定目录中的所有.json或.JSON文件，并将其加载到SQL Server中的表。 

我希望能够遍历每个文件并进行处理。有没有办法做到这一点？

请提供建议或指导我阅读涵盖此主题的材料

先谢谢你的帮助。

---

NKS

解决方案

你好！您是否尝试过ForEach活动（迭代和条件）？

https://docs.microsoft.com/en-us/azure/data-factory/control-flow-for-each -activity

Hi everyone,

Looking for your advice on my situation.

Im processing JSON files that have varying names. So my pipeline should be able to process all .json or .JSON files in a particular directory on BLOB storage and load it to tables in SQL Server. 

And I wanna be able to iterate through each file and process it. Is there a way to do this?

Please provide suggestions or direct me to materials that covers this topic

Thanks in advance for your help.

---

NKS

解决方案

Hi ! Have you tried the ForEach activity (iteration and conditionnals) ?

https://docs.microsoft.com/en-us/azure/data-factory/control-flow-for-each-activity

这篇关于从blob存储中加载与特定字符串模式匹配的所有文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！