1,568 questions with Azure Data Lake Storage tags

Sort by: Updated
1 answer

Azure Storage account tier availability

Hi, We plan on using Lifecycle policies in Azure Storage Account (ADLS). I know there are different SLAs for tiers. The question is: if a blob is in cold tier and this tier is unavailable, can we move it to hot tier and the blob can be read again? Would…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-08-04T09:24:28.7833333+00:00
Artur Basinski 0 Reputation points
commented 2025-08-11T05:29:23.6133333+00:00
Pranitha Maddi 5 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

how to get SLA% of a storage account

we knew there a metric Availability showing the SLA% of a storage account (https://learn.microsoft.com/en-us/azure/azure-monitor/reference/supported-metrics/microsoft-storage-storageaccounts-metrics#category-transaction ), but this metric also contains…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-07-30T06:21:34.4133333+00:00
Gallatin 21V 246 Reputation points
accepted 2025-08-08T09:24:33.44+00:00
Gallatin 21V 246 Reputation points
0 answers

Connecting to Azure Data Lake Storage Gen2 from Tableau Desktop is throwing error

Error Receiving in Tableau Desktop: Tableau received an OAuth error from your request. Please see the error message for more information: User authorization failed (invalid_client). When checked the auth url it seems the url is the one like below -…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-01-31T21:06:38.6066667+00:00
Deep Saha 0 Reputation points
edited a comment 2025-08-07T07:56:41.85+00:00
VarunTha 14,860 Reputation points Microsoft External Staff Moderator
2 answers

Exporting D365 F&O Data Directly to Azure Data Lake Gen2 Without Dataverse. Questions on Current Approach, Format & Folder Structure

Hi Everyone, I’m currently working on exporting all tables/entities from Dynamics 365 Finance and Operations (Tier 2 environment) directly to Azure Data Lake Gen2. I don’t want to use Dataverse in between. I’ve already created a Storage Account in Azure…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-07-29T07:42:22.92+00:00
Hafiz Hassan Mahmood Raja 0 Reputation points
answered 2025-07-29T13:12:19.18+00:00
Nandamuri Pranay Teja 4,445 Reputation points Microsoft External Staff Moderator
1 answer

401 Unauthorized "Audience validation failed" from ADLS endpoint

We are using service principal credentials to authenticate using OAuth2 token. Fetching the access token step is successful however, request getting failed when hitting ADLS endpoint . Error response : Exact error message :…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2024-05-03T11:11:59.4933333+00:00
Shubhank 0 Reputation points
commented 2025-07-28T10:24:18.03+00:00
Ganesh Patapati 8,755 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How to enable Managed Identity for accessing an ADLS Gen2 storage?.

How to enable or use Managed Identity for an ADLS Gen2 storage, instead of using storage access keys.

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-07-24T22:28:25.4766667+00:00
Amit Puthenpura (Wipro Ltd) 20 Reputation points Microsoft External Staff
accepted 2025-07-25T17:29:44.9833333+00:00
Amit Puthenpura (Wipro Ltd) 20 Reputation points Microsoft External Staff
1 answer One of the answers was accepted by the question author.

Transactional Data Vs Non Transactional Data : Partition Depth

Please can I have some perspective on storing Transactional Data in ADLS Gen2. I have read that we should store in Day wise partitions although the write operation could be slow but read operation could be faster. We have set of T and NT tables whose…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-07-18T16:31:29.71+00:00
Anand Deshpande 40 Reputation points
commented 2025-07-18T16:54:00.6966667+00:00
Nandamuri Pranay Teja 4,445 Reputation points Microsoft External Staff Moderator
1 answer

How to form Delta lake tables on top of Parquet files stored in ADLS GEN 2

Hi, Good day! I'm looking for some guidance on how do I create Delta Lake tables on top of Parquet files stored in ADLS Gen2. The constraint here is we don't have Databricks whitelisted by our organization policies. The ultimate goal is to perform CDC…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-07-11T05:54:47.9433333+00:00
Anand Deshpande 40 Reputation points
commented 2025-07-15T07:17:54.9033333+00:00
Nandamuri Pranay Teja 4,445 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

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 Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,422 questions
asked 2024-05-08T03:27:38.5+00:00
Salander He 66 Reputation points Microsoft Employee
answered 2025-07-09T19:01:00.0433333+00:00
Dipanjan Karmakar 0 Reputation points Microsoft Employee
1 answer

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
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-07-03T08:16:43.1866667+00:00
Christoper Wulur (ext) 0 Reputation points
commented 2025-07-07T02:42:46.46+00:00
Nandamuri Pranay Teja 4,445 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

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
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-07-02T18:36:00.1666667+00:00
Moshi Musukwa 20 Reputation points
commented 2025-07-03T17:04:45.3466667+00:00
Moshi Musukwa 20 Reputation points
1 answer One of the answers was accepted by the question author.

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
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-07-02T16:54:29.0666667+00:00
Relay 260 Reputation points
accepted 2025-07-03T02:10:40.85+00:00
Relay 260 Reputation points
1 answer One of the answers was accepted by the question author.

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
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-06-18T13:43:02.8566667+00:00
Relay 260 Reputation points
accepted 2025-06-19T04:32:37.6966667+00:00
Relay 260 Reputation points
1 answer One of the answers was accepted by the question author.

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
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-06-09T20:24:18.4133333+00:00
Venkateswarlu Pottapalli 40 Reputation points Microsoft External Staff
accepted 2025-06-09T23:08:53.4933333+00:00
Venkateswarlu Pottapalli 40 Reputation points Microsoft External Staff
1 answer One of the answers was accepted by the question author.

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
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-06-05T18:53:09.0166667+00:00
LanceKramer-6297 20 Reputation points
accepted 2025-06-09T14:55:49.67+00:00
LanceKramer-6297 20 Reputation points
3 answers

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 Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,614 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,759 questions
Azure Database for PostgreSQL
asked 2023-07-17T13:56:46.3466667+00:00
Shambhu Rai 1,411 Reputation points
answered 2025-06-04T06:21:20.8966667+00:00
Dennis Schulist 0 Reputation points
2 answers

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 Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,226 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,590 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,422 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,759 questions
asked 2024-04-01T14:00:18+00:00
Aditya Singh 160 Reputation points
commented 2025-06-02T14:29:04.2166667+00:00
Lennart Bauer 0 Reputation points
1 answer One of the answers was accepted by the question author.

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
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-05-28T15:13:49.77+00:00
azure_learner 695 Reputation points
accepted 2025-05-29T07:49:48.7+00:00
azure_learner 695 Reputation points
1 answer

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
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-05-20T05:25:24.1866667+00:00
Adeymola 0 Reputation points
commented 2025-05-23T21:07:06.0833333+00:00
Syed Aaqid Ali 580 Reputation points Microsoft External Staff Volunteer Moderator
1 answer

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
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,568 questions
asked 2025-04-30T11:50:59.89+00:00
Varun Reddy Gurram 0 Reputation points
answered 2025-05-09T18:13:37.97+00:00
KarishmaTiwari-MSFT 20,787 Reputation points Microsoft Employee Moderator