I'm building CI/CD for my Azure Data lake Analytics - USQL code and facing below error while deploying my release using VSTS Power Shell task.
"Access from 'example-app1' is denied. Please grant the user with necessary roles on Azure portal. Trace: 03e7229d-e7ca-43d5-a7be-6e0a3a3b9317"
I have created Azure AAD following this link - https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-create-service-principal-portal and created a service End point. I also gave access to this AAD (example-app1) in my Azure Data lake analytics store path. Below is my ADLA - USQL code -
@searchlog =
EXTRACT UserId int,
Start DateTime,
Region string,
Query string,
Duration int?,
Urls string,
ClickedUrls string
FROM "adl://adlacicd.azuredatalakestore.net/Samples/data/SearchLog.tsv"
USING Extractors.Tsv();
OUTPUT @searchlog
TO "adl://adlacicd.azuredatalakestore.net/Samples/data/output/SearchLog-first-u-sql.csv"
USING Outputters.Csv();
any help in resolving this issue would be great.