Azure Data Lake Analytics Retirement - Frequently Asked Questions
On 29 February 2024, we will retire Azure Data Lake Analytics and this service will no longer be available. Before that date, please migrate your services that were deployed using Azure Data Lake Analytics to another Azure data processing product of…
Azure Data Lake Storage
Azure Data Lake Analytics

Sharing connection in Microsoft Fabric inconsistent in dataflow
Hi, Regarding Microsoft Fabric, I couldn't find the right tag to ask this question. Issue We are having issues while establishing connections through "Manage connections and gateways." In the Dataflows of some workspaces, I am not able to view…
Azure Data Lake Analytics
Azure datalake and consistent data
Hi Friends, I am a bit perplexed by some of the datalake aspects which are : We have identified the large number of data sets that are of low to medium data range, the reason being optimizing transaction access patterns (fewer datasets the less I/O…
Azure Data Lake Analytics
Passing Parameters from ADF to ML Designer Pipeline
I have created an ML pipeline using Azure ML Designer, which includes an Execute Python Script component. This component is linked to a script bundle that processes a blob from Azure Blob Storage and saves the output back to the storage. The ML pipeline…
Azure Data Lake Analytics
can we add multiple containers in Microsoft Fabric Data Lake house?
I want to add one more container in Microsoft fabric lake house, as per my knowledge we can add only one container but i am curious to know can we add multiple containers in Microsoft fabric lake house
Azure Data Lake Storage
Azure Data Lake Analytics
Unable to connect scope linked service from ADF
Hi Team, I am attempting to use the scope task in ADF to run my scope scripts, but the connection is failing despite having all the necessary permissions for ADLA. I am using a System Assigned Managed Identity (SAMI) to connect to my ADLA with the…
Azure Data Factory
Azure Data Lake Analytics
Getting TokenNotFoundInConfigurationException error when uploading a Python wheel as workspace package in Synpase
Hello Everyone I'm using Azure Synapse to run my Spark pipelines. I've build my pipeline to use a custom library code from utils package of the same project to perform some operation. To access the utils.pipeline file, have packaged my entire project in…
Azure Data Lake Storage
Azure Synapse Analytics
Azure Data Lake Analytics
When generating a SAS token, specifying the path causes an authorization failure.
I use following code to generate SAS token, when path is null or empty string, it's working. String sasToken = new DataLakeSasImplUtil(signatureValues, container, path, true) .generateUserDelegationSas(userDelegationKey, accountName,…
Azure Data Lake Storage
Azure Data Lake Analytics
How to Use System-Assigned Managed Identity for Secure Access to Blob Storage in Synapse Notebook?
Hello Community, I'm currently working on a project in Azure Synapse Analytics and would like to enhance the security of my data access. My Python code in the Synapse notebook currently accesses Blob Storage using a connection string, but I want to…
Azure Storage Accounts
Azure Blob Storage
Azure Synapse Analytics
Azure Data Lake Analytics
Azure App Service

Workspace request validation failed
Can anyone solve this issue…
Azure Synapse Analytics
Azure Data Lake Analytics
Invalid api-version exception when submitting job to Data Lake Analytics using Azure Python SDK
I got below exception when I tried to submit a job to Azure Data Lake Analytics using Azure Python SDK. CloudError: Azure Error: InvalidArgument Message: Job type 'USql' is not supported by api-version '2017-09-01-preview'. First I have installed the…
Azure Data Lake Analytics
After using api to purge data from workspace the status stays on pending and logs are not removed.
After using api to purge data from workspace the status stays on pending and logs are not removed. While using the status endpoint the status keeps returning as 'pending'. The purge request is visible in activity logs of the workspace but just shows…
Azure Synapse Analytics
Azure Data Lake Analytics
Why is the activity log stored in the adls gen2 container not a valid json
Why is the activity log stored in the adls gen2 container not a valid json? It's line by line, and the outer layer is missing '[]' and comma separation
Azure Data Lake Storage
Azure Data Lake Analytics
How does Azure integrate with IoT devices for real-time data processing?
I’m interested in understanding how Azure integrates with IoT devices to enable real-time data processing. What services and tools does Azure offer to process, store, and analyze IoT data streams efficiently? Any examples of how businesses are using…
Azure IoT Hub
Azure Data Lake Analytics


I got this error when debug my copy data on azure df 7cf2da46-b65b-4098-b8ec-d9c7858c190e
after connecting my Azure data factory to MsSqL, I tried to copy my data into azure data factory and I got this error 7cf2da46-b65b-4098-b8ec-d9c7858c190e
Azure Data Lake Storage
Azure Data Factory
Azure Data Lake Analytics
Azure Data Studio
How to optimize real-time Power BI dashboard through Azure
Hi, I have a Power BI dashboard that displays real-time API traffic data which is working well so far. The Concern is, as the data is stored in an SQL database and connected to BI directly and as database grows, the querying and display times are getting…
Azure Data Factory
Azure Data Lake Analytics
How to send the history of 3 months of files from one directory to another according to the date in its name
Hello, I'm having problems because I want to move the history of some files stored in a data lake according to the date in its name, but in the end what I manage to do is only move either one specific day or all of them. example: I have files October -…
Azure Data Lake Storage
Azure Data Factory
Azure Data Lake Analytics
hii want to run stored procedure in synapse but ima getting an error ,can anyone help me
query: USE gold_db GO CREATE OR ALTER PROC CreateSQLServerlessView_gold @ViewName nvarchar(100) AS BEGIN DECLARE @statement VARCHAR(MAX) SET @statement = N'CREATE OR ALTER VIEW '+@ViewName+' AS SELECT * FROM OPENROWSET(BULK…
Azure SQL Database
Azure Storage Accounts
Azure Synapse Analytics
Azure Data Factory
Azure Data Lake Analytics
Azure Data Lake Gen2 Disaster Recovery/Storage account failover Capabilities?
I am trying to wrap my brain around Azure Data Lake Gen 2 DR/Storage account failover capabilities and I feel as though I am getting conflicting information. On the Microsoft Documentation -…
Azure Data Lake Storage
Azure Storage Accounts
Azure Data Lake Analytics
remove chars from integer columns in databricks delta
Hi Expert, how to remove chars from column in databricks delta when datatype is not null col1 1 2 3 er ge e