Look up in adf
Hi, What is the difference between data flow look up transformation and normal look up transformation.. Any screen appreciated
Function in adf
Hi what are the functions in adf Pls help me with screenshots
ADF-Global parameters inside Linked Service
Hi all! My company is starting to make use of DevOps pipeline to share the same code in all the productive and not productive envirorments. Before this, everything was wild. For example, the linked service for the Azure KeyVault has the url-link written…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
Azure Data Factory Copy Activity convert sql string in to jobject
I have a query from Azure SQL database which returns jsonstring like below and want to insert in to Cosmos db as JSON object (not string) "{\"type\":…
Config table in adf
How we can load table from config table In da pipeline using copy activity.. Help me with screenshot
Copy activity failed: Failure happened on 'Source' side
Trying to get data from PGSQL to blob using copy activity give below error after query runs for ~30 min Operation on target Copy Customer failed: Failure happened on 'Source' side.…
Integration runtime setup, Manual setup: Download and install integration runtime Page not found
I am writing to seek assistance regarding two issues I am encountering with Azure Data Factory Integration Runtime setup. Express setup Internal Server Error: Whenever I attempt to select "Option 2: Manual setup" and proceed to "Step…
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
Upsert operation in azure data factory
We want to copy data from production and send it to dev env daily. As a solution, we re thinking to create a pipeline in Azure data factory to fetch all data from source database, scramble PII information for a few columns and send it to a destination…
How does ADF Linked Service for Azure Databricks aligns with Job Compute Policy defined inside Azure Databricks
This is a two-part Question. First Part Context: I have ADF which contains several data pipelines. Some pipeline also includes a databricks notebook as an activity. I have created Linked Service Azure Data Factory to facilitate the pipeline which…
How to generate ETL pipeline for Python code which gives 2 JSON file in response
Requirement : I have python code in my local pc folder which returns 2 JSON file as a output (that code is using API and try to store the data of website in JSON file), I want to create automation for running that python code at particular time using…
RFC table options
Hi, i´m using azure data factory and copy step to copy data from sap. To shrink data volume i´ve tried to use the rfc table option in combination with a pipeline variable. This fails with sap error message, that it cannot parsed, when i hardcode the…
For each count dynamic batch count
I have a scenario in which i need to have provide dynamic batch count in for each loop f. Is there any way to do it. RIghtnow , I don't see any option to give it. We need to give it as hardcoded in pipeline.
how to read excel file data (stored in adls gen2 ) in Azure Data Factory pipeline
I have source excel file which is coming as showing in the format . Please help how to read excel file with that specified format . Please help . Thank You.
ADF Debug pipeline : Use activity runtime
What is the difference between 'Use data flow debug session' and 'Use activity runtime' in debug in Azure Data Factory? I have a pipeline with a Lookup activity followed by a ForEach activity. A lookup file is used to store parameters, and this file is…
adf data flow acitivity stuck in queued status when the pipelines run
when I trigger the pipelines, it got stuck in the data flow activity as queued status
Data Factory's Data Flow cost structure
Hi all, I have a question regarding the cost structure for Data Factory's Data Flow. Is the charge solely per cluster/integration runtime, or are the costs doubled if two pipelines run simultaneously, I mean, both using the same cluster/integration…
How do i refrence my dataset parameter in my base url in azure copy rest activity
Good day, Is there a way i can reference my dataset parameter in my rest copy activity on the base url, am trying to create a dynamic url:
Issues with mi IP address
Hi guys. I am doing a course about Azure and I was checking the section to connect a Blob Storage to SQL Database. When I was setting up my Firewall rules, the first issue I found was that Azure didn't recognize my IPv4 but IPv6 instead so I have to…
![](https://techprofile.blob.core.windows.net/images/5kfUQwbXfkqnY7o5wQqfdA.png?8DAA55)
Azure ADF Copy activity faild
ErrorCode=AdlsGen2OperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid status code 'NotFound'. Account: 'xxxxx'. FileSystem: 'xxxxxx'. Message: 'The…
![](https://techprofile.blob.core.windows.net/images/5kfUQwbXfkqnY7o5wQqfdA.png?8DAA55)
How to deploy user assigned managed identity?
I have a linked service (which is connected to Dataverse) in Azure Data Factory which is being authenticated by user-assigned managed identity. I have created three UAMI for three different environments - Dev, UAT and PROD. The name of the UAMI are -…