Azure SQL Database
An Azure relational database service.
5,098 questions
Trouble reading JSON files from Azure Blob Storage into SQL Server
PhilLepanto
1
Reputation point
I have a file in Azure Blob Storage and I've been able to create an External Data Source in Azure SQL Server. I keep trying to open the JSON file and start parsing it using Azure Data Studio, but I keep getting this error: Msg 4861, Level 16, State 1, Line 2
Cannot bulk load because the file "xxxx_yyyy.json" could not be opened. Operating system error code 5(Access is denied.).
I have stored queries where I've been able to do this before, but I'm not able to run that query without getting the same error. I've tried re-creating my DataSource as well and running these, but the error is consistent.
{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(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma 17,566 Reputation points2022-01-25T05:46:20.02+00:00 Hi @PhilLepanto , welcome to Microsoft Q&A forum.
Could you please provide the code statements and sample JSON file to repro it? Also if you are using SAS token please provide the permission you are using to generate it.
Sign in to comment