Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
How to fix Download Forbidden error when ingesting data using lightingest from azure blob storage to ADX
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I am trying to ingest data from a blob into my ADX database. I have database admin permisson on the ADX database, and a storage blob reader permisson on the container level. I am able to list the file when running my light ingest command, but i am failing due to unable to download the file with access denied.
Azure Data Explorer
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator2023-12-29T19:53:10.4133333+00:00 Hello Tan, Yoong Kiat,
Welcome to the Microsoft Q&A forum.
Per the below document, To ingest data into existing tables, you must have at least Database Ingestor or Table Ingestor permissions. Can you please validate the permissions again?
also, could you please provide us with the detailed error message.
-
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
2024-01-05T00:26:58.68+00:00 Hello Tan, Yoong Kiat,
I am checking to see if you had a chance to look into my above response.
Sign in to comment
Sign in to answer