Azure Data Factory error creating blob
Hi, I have a pipeline in Azure Data Factory that queries Cosmos DB for some data and writes this data in a blob storage. It was working until it wasn't. I changed the query in the copy activity for a specific scenario, and when I ran it again it failed…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
How to generate token for client_assertion without certificates?
We have an app registration which is connected to an external API. We have to use this API in our Azure Data factory. For this purpose, till now we were generating client secrets and generating tokens (in Azure Data Factory) from this URL -…
फोनपे पर पर शिकायत दर्ज कैसे करें?
इस ऑफर के लिए ग्राहक से संबंधित सभी प्रश्न फोनपे/care या 09831-228932 पर पूछे जा सकते हैं...
मैं फ्लिपकार्ट से शिकायत कैसे कर सकता हूं?
अपनी शिकायत दर्ज कराने के लिए फ़्लिपकार्ट के टोल-फ़्री ग्राहक सेवा नंबर पर कॉल करें। फ़्लिपकार्ट ग्राहक सेवा अधिकारी से बात करने के लिए 08167-8298-78 या (081)67829-878 डायल करें। आपको अपनी समस्या को स्पष्ट और संक्षिप्त तरीके से बताना होगा।
Data Factory monitoring by inserting data table
Hello, I would like to know the best way to insert Datafactory activity logs into my Databricks delta table, so that I can use dashbosrd and create monitoring in Databricks itself , can you help me? I would like every 5 minutes for all activity logs in…
adf from configtable
Hi, how to load tablename from config table and using copy activity at front end... how it will execute it.... let say copy activtiy lookup for tablename then how copy activity will take that...please help with screenshot ...
For each loop in adf
I am running for each loop using look up activity so using look up activity I am getting all the files from blob storage but for each loop is running continuously.. It has 60 files but after getting from files... It is running again... Please screenshot…
ADF managed Airflow tasks fail without running or logs
Hi, I have a managed Airflow instance inside Azure Data Factory. I am seeing a behaviour on a semi weekly basis where tasks scheduled for running suddenly fail with no logs. Whenever I retry any task (regardless of how heavy or light it is). It instantly…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
Internal Server Error while calling azure function from Azure data factory
We have written script to download some files from sharepoint to the azure blob storage. Ii have tested the code locally and on the portal too. This function will copy single files so we have placed azure function activity in a for each activity to run…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
DP-203 Labs
Is there any way to do all the labs for DP-203 without costing alot of money AND without taking like 10 minutes to install something? For each lab, the ./setup.ps1 file takes like 10 or 15 minutes to load. I'd like to not have to delete the resources…
Google drive on Azure without GCP
Hello, I'm wondering what options I have to transfer Google Drive data to Azure without GCP access. I found that the Google Drive API and Google Storage API require a Google Cloud account. What other options do I have to securely connect to and transfer…
![](https://techprofile.blob.core.windows.net/images/nangnqqNAkuWTT7031X8vg.png?8DCA0F)
Test Connection is getting failed in data factory for Mongo DB
Test Connection is failing in datafactory for Mongo DB. Note, Ips are whitelisted but i am getting the below error. Failed to operate data via MongoDB client. An exception occurred while opening a connection to the server. Exception has been thrown by…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
[Legacy Connector] ADF Copy-table from Salesforce (legacy) activity failed
Dear team, We have a pipeline has been running for few years, it copies from sales force org to an SQL table a list of objects. It has been running well, till recently in the middle of the lists , it hangs on different table without being able to…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
Error when loading SQL Server Views into JSON files during COPY DATA activity
I am copying data from SQL Server to Azure Blob Storage as a JSON file with gzip compression using a COPY DATA activity within a ForEach activity. However, if the table from the lookup activity is actually a view in SQL Server, I get an error "Index…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
Azure Data Factory Error- when trying to connect to Azure SQL Database. How to resolve? Why happened?
Spark job failed: { "text/plain":…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
My python code uses AzureCliCredential() function, but it is giving error in running in Synapse/ADF/Databricks notebook .
My python code uses AzureCliCredential() function, but it is giving error in running in Synapse Workspace that your Azure Cli command not found on path . I have tried using other function like DefaultAzureCredentials(), ClientSecretCredentials () also…
The on-prem NAS drive copies data from multiple locations to the Blob Storage
I have a requirement to copy data from a NAS drive to blob storage using Azure Data Factory (ADF). The NAS drive has 51 different locations, examples of which are: T:\scd\in T:\vnd\ed\in T:\tx\rx\in\em T:\rx\gs\tm\in\em The NAS server is denoted by…
ADF Issue with partially uploading data to Cosmos DB SQL API
I am migrating data from one container to another container in Cosmos DB SQL API, where I only changed the partition key. However, when migrating using ADF, it is not writing the complete data at the sink side. Can you please guide me on how to resolve…
ADF Copy Activity - Emply col issue
Hi Team, I have a pipeline where I am copying the data from the file to a database. The file had one extra empty column in between, and my copy activity failed with the below error: Message: Invalid Excel header with empty value It failed because the…
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:…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)