ADF Until activity slow to terminate
I have a number of ADF pipelines that I'm using to download historic transactional data from various external REST APIs. Because of the data volumes involved, the pipelines I've created run for many hours. The API pagination mechanisms are such that I…
How can i get the outbound IP address for Azure Data Factory ?
I need to find the outbound IP of ADF, I see in properties tab it doesn't have IP address list. Is there a way I can get this list ?
Installing IBMi Access Driver on Azure Data Factory Integration Runtime
Hello, I've been trying to install the Windows version of the IBM i Access Driver on a Data Factory Integration Runtime through adding a script (main.cmd) and the desired installer in a Blob Container This script seems to work perfectly locally but when…
load data from ADLS to Unity Catalog tables using Azure Data Factory?
What is the best way to load data from ADLS to Unity Catalog tables using Azure Data Factory?
We have a storage event trigger in adf kicking off pipeline to process file too early?
We have a Storage event trigger, that is set to kick off a Data Factory Pipeline(To process files from blob container folder path ) onto a sql server database when a file is dropped on to the location. The DataFactory Pipeline is a simple pipeline with…
Script Activity not supporting multi-instruction with new Snowflake connector
I have a pipeline, in Azure Data Factory that has an "Activity Script" that executes 3 instructions against Snowflake. The script was working fine until I have updated the Snowflake connection in order to remove the legacy Snowflake connection…
How to Fix the InternalServerError in Executing a ADF Pipeline?
I have a foreach loop in my Azure Data Factory pipeline with three activities. The first activity uses a Self-Hosted Integration Runtime (SHIR) to copy data from an On-premises SQL Server to Azure Data Lake Storage Gen2 (ADLS2). The second activity is a…
Power Query activity in Azure Data Factory - Not supported in region
I've done multiple Bing and Google searches on variations of the following error but haven't found anything helpful. Is a Power Query activity really not supported in the region specified? Is there an article somewhere that explains where this activity…
Inserting Error Logs from Data Factory into Databricks Delta Table (Catalog) - Streaming vs. Batch
Hi everyone, I'm working on a solution to capture and store error logs generated by my Azure Data Factory pipelines. My goal is to insert these logs into a Databricks Delta Table (catalog) for further analysis and troubleshooting. I'm considering two…
SQL Server wont connect to data factory
I recently set up a SQL server and database. However, when I try to connect it to data factory using SQL Authentication, i get the following error Cannot connect to SQL Database. Please contact SQL server team for further support. Server:…
Facing an issue to install dbt-core==1.6.0 and dbt-snowflake==1.6.0
Happens that we’re now facing an issue to install dbt-core==1.6.0 and dbt-snowflake==1.6.0. We found out that ADF UI appears to enable only packages from apache-airflow-providers, and not any that can be installed with pip. (The ones listed here…
Efficient Log Handling and Data Retention in Azure Data Factory and Databricks
I need to create a solution to send logs from Azure Data Factory to the Databricks Unity Catalog. I'm considering the following structure: Whenever an activity run results in either failure or success, the corresponding log will be sent to Azure Logic…
Azure Synapse Analytics Data Flow: How do the Table Actions and Update Methods work & can you conditionally Truncate with 1 Data Flow?
I am working in Azure Synapse Analytics and making a dataflow, but I'm struggling with understanding some things. (I'm using Azure Data Lake Storage Gen 2 and Delta file for my sink) For the sink activity: what is the difference between the update…
Question regarding for each loop in ADF
I'm trying to create a new pipeline in ADF and my requirement is as follows. I have a table 'abc' in my database which contains a list of table names in it. Now, I want to execute a stored procedure which is written in such a way that it checks the data…
Put Blob REST API Content-Length error
I'm trying to write the XML response obtained from a REST API GET request to a file in Azure Blob Storage, using Azure Data Factory. I'd prefer to use the Copy activity to achieve this, but it doesn't support XML sinks. I've therefore been forced into…
Datetime2 error when querying parquet file produced from Synapse copy activity from OData Business Central Source (data seems to be changed from 0001-01-01 to 0000-12-30)
I have a pipeline running a copy activity to copy data from Business Central OData source to parquet file everyday. Everything works fine before 16/07/2024 but problem arises starting from 17/07/2024. The parquet file no longer be able to query from…
How to process this JSON structure
Hi, i get this structure back from a web activity. Showing only a part { "Response": "[\r\n {\r\n "CreationDate": "2024-01-07T00:00:00Z",\r\n "Operation": "ViewReport",\r\n "UserId":…
Azure Data Factory Writing to Business Central Purchase Header and Purchase Lines
Hello @Anonymous I am working on posting data to Business Central using ADF from CSV files to Purchase Header and Purchase Lines tables. I am having the following error on trying to post the data. The sink is a REST. I have checked my permissions on…
How to handle an excel sheet(only 1 tab) with multiple datasets with different columns and ranges
Hi Team, Could you help me out with below Scenario of ADF? I have a single Excel file with just one tab, as displayed below with different columns and that tab contains 2 datasets. We want to move this data to 2 different SQL tables using ADF/data flow.
Delimited Text(CSV) dataset escape/quote character
Hi, I am facing an issue with delimited text(CSV) dataset, whne my data contains comma. So I added quote character in configuration. But this double quotes character is applied for most of the column values, even though the column value doesnt contain…