Does synapse serverless sql pool OPENROWSET support "parquest based structured stream" format?
I can read from a data lake structured stream using synapse serverless sql pool OPENROWSET, by specifying FORMAT = 'SSTREAM'. Does OPENROWSET support "parquest based structured stream" format? If yes, then what value should I specify to FORMAT…
Azure Data Lake Storage
Azure Synapse Analytics
Service Principle cannot access ADLS
Could you help me debug Service Principle has been granted a Storage Blob Data Contributor on the storage account level. However, it cant access the container, 403 Request ID: 9f415b7e-601f-0018-16f1-eb704e000000
Azure Data Lake Storage

Dropped sftp file upload
A file was uploaded to our blob storage via sftp by one of our vendors. Even though it showed the fle was sent it never made it to the xmlfiles container.See logs below. What could have been the cause? weekly inventory valuation Report for 06/28/2025…
Azure Data Lake Storage


Storage Approach Comparison in Azure ADLS Gen2
Hello, May someone please help me with valuable suggestion which approach I should Take. It would be great if share thoughts with Pros and Cons. Scenario 1 : Scenerio 2 : Scenerio 1 Details: 1.Silver layer stored in Azure SQL / Cosmos…
Azure Data Lake Storage
GDPR Handling In ADLS Gen2
I am creating a Centralised Data LAKEHOUSE as shown in Diagram. I have created a Second ADLS Gen2 so it easily connect with Databricks. I am seeking your valuable help in designing ADLS Gen 2 for silver layer. Do This approach is good. Do I need to…
Azure Data Lake Storage
Is it possible to create Lakehouse with case insensitive collation in Fabric?
Is it possible to make lakehouse SQL end point as case insensitive collation, Or is there way to create a lakehouse with case insensitive collation like we create warehouse (https://learn.microsoft.com/en-us/fabric/data-warehouse/collation)
Azure Data Lake Storage
Folder and contents within an ADLS blob deleted, no records within logs
Between the hours of 3:00 PM CST on 6/4/2025 and 8:20 AM CST on 6/5/2025, a folder and it's contents were deleted from one of our storage containers. This folder is not within our deleted items (we have 7 day retention enabled), and I cannot locate any…
Azure Data Lake Storage
create hive metastore in Databricks with non-SQL DB
Hi Expert, How to create Hive Metastore in Azure databricks DB
Azure SQL Database
Azure Data Lake Storage
Azure Databricks
Azure Data Factory
Azure Database for PostgreSQL
Logic app to retrieve the latest file from a blob folder
How can I create a logic app that retrieves the latest file from a blob folder when a Http request is received, where there are multiple files, and sends it as an attachment? Are there any specific steps or configurations required for this process?
Azure Data Lake Storage
Azure Blob Storage
Azure Logic Apps
Azure Synapse Analytics
Azure Data Factory
data lake and database migration
Hi Friends, we are developing a data lake, we are building till bronze layer, now I am in a dilemma. We have a Postgres database data (which is one time load and incremental load afterwards) on premise and we need to move that data into the data lake.…
Azure Data Lake Storage
Content of directory on path 'https://datalakecohswtr.dfs.core.windows.net/files/sales/csv/**' cannot be listed.
I am trying to View Top 100 row of my file but it keeps bringing up error
Azure Data Lake Storage
Generated Storage level SAS token using Logic Apps not working as expected
Hello Team, I did Automate generation of SAS token using http action in Azure Logic Apps. Here is the token generated -…
Azure Data Lake Storage
How to send a mail notification for a failed pipeline in Azure Synapse Analytics?
How can I send a notification email to a specific email address without using a logic app when one of my Synapse Analytics pipelines fails? I would like to include the error message in the email notification.
Azure Data Lake Storage
Azure Blob Storage
Azure Synapse Analytics
Azure Data Factory
Error generated in Synapse when I query dataverse data in Spark Notebook
Hey there, I am having an issue querying the data from the Synapse Link for Dataverse in a Spark Notebook within Synapse. I am able to run a SQL query against the data (which appears in Synapse as a Lake Database) and it returns data. See below …
Azure Data Lake Storage
Azure Synapse Analytics
Developer technologies | .NET | .NET Machine Learning
Ingress and Egress cost in azure
I have gone through below thread: https://learn.microsoft.com/en-us/answers/questions/892660/will-the-ingress-egress-costs-of-a-azure-storage-a but still confused and clear about the ingress and egress costs of ADLS, and what parameters it takes to…
Azure Data Lake Storage
Azure Data Factory

How is AI and Data lake going to work ahead
How is Azure Data lake place in future with AI, Co-pilot. Is Fabric the only way. How can the designing be done. What can help ?
Azure Data Lake Storage
unable to disable download option in azure blob storage for video files
unable to disable download option in azure blob storage for video files
Azure Data Lake Storage
Error trying to validate storage account name while creating a new synapse workspace
I am unable to create a new data lake storage (gen2) account name in the basic tab for create Azure Synapse Workspace. The error I get is - " There was an error trying to validate storage account name. please try again ". The error message is…
Azure Data Lake Storage
Azure Synapse Analytics
Best Archival Strategy for delta parquet in ADLS ?
We have a situation where we will be loading SAP data into ADLS layer using SAP Datasphere in delta parquet format. Now, we want to implement a robust archival framework for this data. Can you please guide/help me with the correct/MS recommended approach…
Azure Data Lake Storage
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
