azure-data-factory

I've created an Azure Data Factory pipeline with one simple Stored Procedure Activity which is supposed to fetch data from a Stored Procedure residing in Azure SQL DB. The Stored Procedure accepts one input parameter. I've published these changes already.…

I have been trying to do a datatype check in a decimal column of a file by using the Data Flow from Azure Data Factory, but it is not working as expected. My issue is the following one: I want…

There is the article about adding credentials in Azure Data Factory: https://learn.microsoft.com/en-us/azure/data-factory/credentials?tabs=data-factory Associate the user-assigned managed identity to the data factory instance using Azure portal, SDK, PowerShell, REST API. I am interested in PowerShell or REST API option, the process…

I am trying to replace single quote in a string with double quote using replace function with data factory expressions. For example, replace single quote in the following string hello'world ---> hello''world @replace(pipeline().parameters.tst,''','''') The above code is not working. Need…

I am getting error while I am reading Parquet file created by Databricks on ADLS. While I read these files using Databricks it works perfectly fine and I am able to read and write data into these files from Databricks.…

I have a requirement, where I want to get the ADLS storage account name and use it in an activity. I am using Event based Trigger and I can get the container name, folder path and the file name from…