Category "azure-data-factory"

Can an ADF pipeline change its Concurrency number based on a calculated condition?

Background I have an ADF pipeline that takes jobs from a “3rd party” queue (ueing a REST call), completes jobs and marks the queued message as compl

Error on source dataset with REST Connector in Azure Synapse pipeline

I am using Copy and transform data from and to a REST endpoint by using Azure Data Factory to load a file from my Box.com account to an Azure Data Lake Gen2 (AD

display aggregate function output in trailer record

We are reading csv file input which has two fields. Sample input file is given for reference source, balance 1,100 2, 200 I need to create a trailer record in

how to pass parameter to python script from a pipeline [closed]

I am building an Azure Data Factory pipeline and I would like to know how to get this parameter into the python script. The python script is l

How do I list all paths in Azure data lake gen 2 filtered by last modified date in Azure Data Factory?

We have an Azure Data Lake Gen 2 which contains 100's of thousands of JSON messages that come in on a continuous basis. These files are stored in a folder struc

Data Factory/Synapse: How to merge many files?

After generating ~90 different 100 mb gzip'd CSV files, I want to merge them all into a single file. Using the built-in merge option for a data copy process, it

Azure Data Factory (ADF) - Parse/Flatten XML file - Get content of all elements match wildcard criteria and sitting in different segments in Hierarchy

I have XML file something like below and need to get all complex elements having different names but all ends with "_KEYS" and they are part of different segmen

ADF: manage token expiration in copy data activity

I am trying to copy data from a REST API into an Azure SQL Database table. The copy data activity uses pagination and can run longer than 10 minutes after which

Azure Data Factory not interpreting well an array global parameter

We have an Azure Data Factory using Global Parameters, it's working fine on our Dev environment, but we when try do deploy it to QA environment using an Azure D

How to prevent data factory from running out Cosmos DB RU/s

Description When I copy data from Storage to CosmosDB by Azure data factory, the Cosmos DB RU/s is full and nobody can use it during this time. I want other ope

Removing specific rows in an Excel file using Azure Data Factory

I have a set of excel files inside ADLS. The format looks similar to the one below: The first 4 rows would always be the document header information and the la