8. How to filter out records based on pipeline parameter using mapping dataflow

preview_player
Показать описание
In this video we learnt how to filter out records based on runtime value provided during pipeline execution using mapping dataflow
#adf
#azuredatafactory
#azuresynapseanalytics
#datafactory

Input dataset:
{
"value": [
{
"data": [
{
"uuid": "bdc0b51c-9888-4a2c-831d-744edb55d9fb",
"status": "open"
},
{
"uuid": "1a79036b-84c7-4232-8585-31be3775d95c",
"status": "closed"
}
],
"pagination": {
"currentPage": 1,
"totalCount": 4,
"nextPage": 2 }
},
{"data": [
{
"uuid": "8da907f6-b8a5-4119-b671-1be501e83bf0",
"status": "closed"
},
{
"uuid": "d0faf159-a712-47db-a7ab-83e44591a2c6",
"status": "open"
}
],
"pagination": {
"currentPage": 2,
"totalCount": 4 }
}
]
}
Рекомендации по теме
Комментарии
Автор

Nice one again Annu, I started learning dataflow only watching your videos. Really good. Waiting for next one

sdhilip
Автор

Nice one, by the way one small query what type of setting is provided in sink, it is truncate and load each time to SQL?

joseantony
Автор

can i filter in the flattern with expression maybe?

Victor-hbhi
visit shbcf.ru