使用条件将Blob数据复制到Azure数据工厂中的Sql数据库 [英] Copy Blob Data To Sql Database in Azure Data Factory with Conditions
问题描述
我正在执行一个基于触发器的管道,将数据从blob存储复制到SQL数据库。在每个blob文件中都有大量的JSON,我需要从中复制其中的一些,我可以根据每个
JSON中存在的键值对来区分它们。
那么如何过滤那些包含与公共密钥对应的值的JSON?
。现在,当复制活动发生时,它应该根据事件名称过滤数据。它看起来像 -
{Event { Name:" .xyz .." ,data:" 21w781"} }
。
这里回答类似的问题。
I am performing a a trigger based pipeline to copy data from blob storage to SQL database. In every blob file there are bunch of JSONs from which I need to copy just few of them and I can differenciate them on the basis of a Key-value pair present in every JSON.
So How to filter those JSON containing that Value corresponding to a common key?
. Now While the copy activity is happening ,it should filter data according to the Event Name. It looks like -
{Event { Name : ".xyz..", data :"21w781"}}
.
The similar question is answered here .
这篇关于使用条件将Blob数据复制到Azure数据工厂中的Sql数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!