reusable extract pipeline and modular ADF framework
We are delivering an 80TB data migration project for a healthcare client, migrating from on-prem IBM DB2 (via FlashCopy and CDC) to Azure SQL Hyperscale using Azure-native services. The architecture supports one-time historical, catch-up, and real-time…
Azure Data Factory
Continuous vs. Phase-Specific Pipelines for Retry and Reconciliation (ADF + Databricks)
In our healthcare data migration project, we are using a modular, control-table-driven architecture for One-Time, Catch-Up, and Real-Time phases. The pipeline processes are divided across Extract, Transform, and Load stages — primarily orchestrated via…
Azure Data Factory
PstgreSQL Linked Service works, but not with debug.
Hi! I am getting this error when trying to use data preview in a dataflow with my dataset which I get from a postgresql db. Spark job failed: { "text/plain":…
Azure Data Factory
Multiple pipeline runs triggered when a file is created
We are creating a file using mssparkutils put method of size 0kb. Just a simple success file. But when this file is written or kept at gen2 location, the trigger which is storage based trigger, is triggered twice due to which same pipleine is triggered…
Azure Data Factory

How to resolve Budget Export Error from FinOPS HUB Deployment ADF 'error':{'code':'NotFound','message':'The requested export with export name: finops-hub-monthly-costdetails could not be found.'}}
Hi Team, We have integrated FinOps Hub Toolkit tools into our subscription to leverage cost analytics and insights from our budget spending. However, we are seeing a problem with the FinOPS hub deployed ADF exporting budget data into Storage accounts. We…
Azure Data Factory

ADF copy activity loading 2 different files into same variant table
so when am loading data from azure blob to snowflake variable table, its copying the content of 2 files into one variant table i.e. students 2 files in blob - sql.students, sql.subjects 2 variant table in snowflake - stage.sql_students_variant &…
Azure Data Factory
recommended SHIR configuration to ingest 80TB from DB2 Snapshot to ADLS Gen2 via ADF within 3 days?
We are performing a large-scale one-time data migration project. Our source is an IBM DB2 snapshot (on-prem), and the target is Azure Data Lake Storage Gen2. The entire data volume is ~80TB, distributed across 800 tables. We are using Azure Data Factory…
Azure Data Factory
ADF Copy Activity Generating negative acknowledgements on SFTP Server while execution.
The Copy Activity in Azure Data Factory (ADF) is configured to copy files from SFTP Server. This copy activity is triggering a negative acknowledgement (NACK) first on the SFTP server while downloading the files and after a few seconds file copy is…
Azure Data Factory
Key-pair Authenication snowflake authenication using linked Service
Please I need assistance with resolve the error message i got while connection to snowflake using Key-Pair Authentication. I followed the procedure outlined in both snowflake and Azure Data factory. I'm still getting the same error message see…
Azure Data Factory
How to Report File Metadata for 2000+ Files Uploaded by Multiple Users to Azure Blob Storage
Hi Team, I would like to know following questions. Please do needful. 1.How to Report File Metadata for 2000+ Files Uploaded by Multiple Users to Azure Blob Storage 2.How to connect Hadoop hive to databricks Regards, Prasad, 5017654887.
Azure Data Factory
How does Azure Data Factory handle data movement ?
How does Azure Data Factory handle data movement and transformation across hybrid environments, and what are the best practices for optimizing pipeline performance and cost efficiency
Azure Data Factory
How to iterate through Nested folders and read file after the file in adf
Hi, How can I iterate through folder and inside subfolder by folder and process one file after another without using regex in azure data factory
Azure Data Factory
Seeking solution for intermittent "SqlFailedToConnect" errors when writing to Azure SQL Managed Instance from Azure Data Factory
I have multiple ADF pipelines that copy data from a variety of sources into our Azure SQL Managed Instance. All of these jobs, regardless of source, fail intermittently with a Sink error such…
Azure Data Factory
Recommended approach to update reconciliation log tables during DB2-to-Azure SQL Hyperscale migration using ADF + Databricks
We are migrating data from IBM DB2 to Azure SQL Hyperscale using a combination of Azure Data Factory (ADF) and Azure Databricks. As part of our reconciliation framework, we calculate row counts and hash values within Databricks after each major stage…
Azure Data Factory
Error while running data factory pipeline in fabric
Hi Team, I am getting below error while executing data pipeline in fabric. Can you please help me on this how to resolve it. Failed to get User Auth access token. The error message is: Failed to get User Auth access token. The error message is:…
Azure Data Factory
Error: 11402 -The value of the property '' is invalid: 'The remote name could not be resolved:
I am setting up a Linked service for ODATA in ADF, for IntegrationRuntime I am selecting "AutoResolveIntegrationRuntime" but connection to ODATA resource is failing: The value of the property '' is invalid: 'The remote name could not be…
Azure Data Factory
Can't get Data Factory to recognize string as Time Stamp
I keep getting the following error when trying to upload data from a csv file to a database: "Operation on target Copy_SR_to_THER47 failed: ErrorCode=TypeConversionFailure,Exception occurred when converting value '2023-01-25 04:51:07' for column…
Azure Data Factory
data extraction issues since upgrading to Odata 4.0 in ADF
Our data extraction process, using the Odata connector in ADF has shown problems since our client upgraded their service to Odata 4.0. The issues consist of not succesfully extracting an endpoint. Our client shows that their network gets overloaded even…
Azure Data Factory
dataset showing warning even after updating linked service version from 1 to 2
ADF dataset showing warning even after updating linked service version from 1 to 2 also tried to refresh the page tried to reopen the ADF ports but still the same warning also the test connection is successful in linked service after updating…
Azure Data Factory
ServiceNow Incident table extraction with V2 Connectors
Using the new ServiceNowV2 connectors in Azure Data Factory, we are trying to extract the incident table. When setting up a copy activity, we receive the error message below. I have tried to limit the number of records by providing a filter to small…