Copy Activity Error when copying from Oracle to ASQL
Hi, I have been trying to do a simple copy activity from Oracle to Azure SQL Server. The source script is 'select * from Tableschema.TableName' and the target is the table name. The Oracle table contains over 4.5 million records. The copy…
Issues while fetching data from cosmos db using data factory
Hi All, I have been trying to fetch data from cosmos Db using a query which works well in cosmos Db explorer in Azure portal. But, the same query gives error while using it with Azure Data Factory. Query: SELECT * FROM c where…
Copy data vs Data flow for cost
Hi Team, I am new In azure data factory what different between Copy data vs Data flow As my understand Copy data free (No Billing) Data flow is Billing each activity Please anybody help me. Thanks Shanvitha
ADF Internal Server Error.
In Azure Data Factory I am getting 'Internal Server Errors' when testing the connection of Linked Services and setting up Datasets. I get these errors in my own tenant as well as the tenant for the client I am working for at the moment. Both are located…
Immediate restartability on failure of execute pipeline activity
There is a requirement to rerun the master peipline from the failed execute pipeline activity and its dependent tier pipelines. Though the existing capability helps to rerun the activities from the failed point but this only could be done after the…
Power Shell Script Give Errors, While Stopping Triggers at Azure Data Factory
Hi, I am creating a release pipeline for the Azure Data Factory and My Data Factory Contains Triggers . Now I As we know that Before DataFacctory Release Deployment we have to Disable running triggers and we can use Azure Power shell script for that …
User configuration issue in azure pipeline in data factory
Hi, one of my users is facing below issue i am not able to find out why he is getting such error .. error code : 2402 Failure type : user configuration issue details : execution failed against sql server with error number 15165 .. could not…
Updating RU value of a container in Cosmos DB from ADF pipeline
Hi, I'm just curious to know whether anyone has tried updating the RU value of a container in Cosmos DB account using ADF pipeline. If yes, please share the details.
Error while loading data from Azure Data Lake Gen2 to Azure Synapse Analytics using Azure Data Factory
Hi All, I am getting an error while loading data from Azure Data Lake Gen2 to Azure Synapse Analytics using Azure Data Factory. I am unable what exactly the error is? What permission has to be provided? How?. This error occurs when I use Polybase…
Load CSV to ADLS by Date
I have a large CSV file that contains a extract of records dating back to year 2016. The requirement is to copy the data into azure data lake but in year/month/day.csv format. What is the best approach to implement this? I am aware of how to achieve the…
Azure Blob Storage Dataset Wild card file name
Hello, I have a requirement where in the user will upload delimited file in the Azure Blob Storage and the Azure Data Factory pipeline will copy the file from Azure Blob Storage and dump it into Azure SQL DB. To achieve this, I have created…
Azure Data Factory - Self-Hosted Integration Runtime to Storage Account Error
Hello experts, I am having an issue validating one of my pipelines: Anyone have any ideas what this message actually means? I am not sure if this is networking, storage account or data factory issue. Thanks
ADF - cosmos upsert question
Hi I have a file that has a million rows - which i upload into cosmos db, I let cosmos db generate the id as a guid next day i get a new complete file which has some deltas and new records - there are two fields I can check to see if the record…
Pagination issue in Azure Data Factory
I'm trying to fetch data from API where the result is split over multiple pages, The response from API is something as below. { "story_count": 212, "next": "?page=2", "previous": null, "results": [{ I…
Can we replace SAP CPI iFlows with Datafactoy pipelines?
Hi, We saw that datafactory has copy activity for SAP C4C. https://learn.microsoft.com/en-us/azure/data-factory/connector-sap-cloud-for-customer Can we consider to not use SAP CPI iFlows but use above Copy activities in ADF pipelines for…
semaphore timeout in copy activity from Azure SQL DB to Blob Storage
Hello, We are trying to copy a large table from an Azure SQL database to blob storage but we keep getting the below error. The table has about 9.4 million records in it. Any ideas what is causing it? Thanks! Error: …
Unable to connect the Azure SQL DB from ADF
Hi, I am trying to pull data from an on-prem SQL Server database into an Azure SQL database, a simple pipeline in ADF. I have installed Integration runtime on a on-prem VM which is configured and seems to be linked successfully to my data factory. I…
Add REST API Json response data into Azure SQL database using Azure Data Factory
Hello Everyone, I want to insert data in multiple tables using single REST API Json response into Azure SQL Database using Azure Data Factory. I am not able to insert all the list of data in different tables using stored procedure. For e. g., I have…
byName function to select column value from a json dataset in dataflow
Hi, I have a dataset with json data as source in a dataflow and want to add a derived column to the stream that will be calculated like this concat('/folder/',toString(byName('attribute')),'.json') This works fine But it my attribute is nested…
function app not reading / getting body in azure data factory?
I have a simple azure data factory pipeline consisting on a function app that takes two pipeline variables and a fixed string as a third input as part of the body. The function runs without problems in local dev. But when triggered in ADF it throws an…