Hello, I have one question. Suppose I have a complex sql query. Now I want to create one pipeline where I can store the output of this sql query as parameters , so that other pipelines who will call this pipeline can use these values. How to achieve that in adf?
I am able to pass parameter to Linked Service using Advance Json. I am using Salesforce connector. While testing connection from linked service it works when we pass value for parameters. However, when we use that linked service in a dataset and try to test connection or use dataset by passing valid parameter values it doesn't authenticate the user. Can you please suggest any cause for this and how can we further debug/resolve the issue?
Hi ; ), Is it possible to parameterize the Linked Service where values are stored in a out source Table ? For instance access the value in the table via the Lookup then strore the value in a variable and then put it into the Linked Service ?
Thank you for your videos! Very good one! Have tried to do similar thing for auth header for http linked service but it seem to be not able to get the parameter. Any hints on that please?
Hi Maheer , is it possible to parameterized an Azure Blob Storage type Linked Service ? I have a Global parameter storing the name of blob storage account , that varies between dev-qa-prod environment, I would like pass that global param value to the Linked service, not sure how. Please help. I have already watched your video #17 and #94.
I have one doubt, in blob dataset how to take/consider all json files having the below strict in storage account Storage acc ----containers------>somename---->subfolders(have multiple) ---->*.json file Now how to consider all the json file in each and every sub folder
Hello,
I have one question.
Suppose I have a complex sql query. Now I want to create one pipeline where I can store the output of this sql query as parameters , so that other pipelines who will call this pipeline can use these values. How to achieve that in adf?
Nice explanation ,very useful 👍 👌 👏
Thank you ☺️
I am able to pass parameter to Linked Service using Advance Json. I am using Salesforce connector.
While testing connection from linked service it works when we pass value for parameters.
However, when we use that linked service in a dataset and try to test connection or use dataset by passing valid parameter values it doesn't authenticate the user.
Can you please suggest any cause for this and how can we further debug/resolve the issue?
Very useful workaround. Thank you for sharing
Thank you 😊
Hi ; ), Is it possible to parameterize the Linked Service where values are stored in a out source Table ? For instance access the value in the table via the Lookup then strore the value in a variable and then put it into the Linked Service ?
Underrated video!
Thank you for your videos! Very good one! Have tried to do similar thing for auth header for http linked service but it seem to be not able to get the parameter. Any hints on that please?
Hi Maheer , is it possible to parameterized an Azure Blob Storage type Linked Service ? I have a Global parameter storing the name of blob storage account , that varies between dev-qa-prod environment, I would like pass that global param value to the Linked service, not sure how. Please help. I have already watched your video #17 and #94.
Great explanation. Thank you
Thank you ☺️
I have one doubt, in blob dataset how to take/consider all json files having the below strict in storage account
Storage acc ----containers------>somename---->subfolders(have multiple) ---->*.json file
Now how to consider all the json file in each and every sub folder
By the way I only asked for parameterization if linked services....so thanks
Nested For each Loop
@@ravitutika1204 can you explain how visually we can do instead of using code language (like any activities)
@@ravitutika1204 Nestted For each loop not work in adf.
I got job Bcoz of you..Tqs a lot.
Congratulations 👏 all the best for your future 😊