I have set up an Azure Synapse Serverless SQL Pool, with the goal of reading data from a Parquet data lake stored in an Azure Data Lake Gen2 container.
Within Synapse Studio, I can create an SQL script as below, which works:
SELECT TOP(50) AVG(Speed)
FROM serverlessdbtest.dbo.CAN2_gnssspeed
I am now trying to do this externally from a Grafana Cloud account. I have done the following:
- Added a Microsoft SQL Server data source
- In the authentication I used the below settings:
Note here that the user details I have specified come from below:
The above lets me connect to the Azure Synapse database and within a Grafana panel I can e.g. use the builder to show my tables, columns etc. But when I try to execute the aforementioned query in Grafana, I get the below error:
db query error: mssql: External table 'serverlessdbtest.dbo.CAN2_gnssspeed' is not accessible because content of directory cannot be listed.
It seems the issue is that I need to add a Storage Blob Data Reader role to my user, sqladminuser – but it is unclear where I do this and how. Any hints would be appreciated.