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.
501 questions
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(99.2, 41%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETY%3C/text%3E%3C/svg%3E)
Tan, Yoong Kiat
0
Reputation points
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.
{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)
BhargavaGunnam-MSFT 28,526 Reputation points Microsoft Employee2023-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.
-
BhargavaGunnam-MSFT 28,526 Reputation points Microsoft Employee
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