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
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
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
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

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
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
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

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

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
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
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
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
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
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
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
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…