Azure U-SQL Continous deployment using VSTS Powershell task

0
votes

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.

1
azure-data-lakeu-sqlazure-pipelines-release-pipeline
I am not seeing any error related information in your question? – Peter Bons
Sorry Peter updated my question now.. – Arun S
What's the result if you try it with relative path docs.microsoft.com/en-us/azure/data-lake-analytics/…? On the other hand, provide the detail steps you gave access to AAD. – starian chen-MSFT
Thanks Starian. I changed my path in my script as below - /Samples/data/SearchLog.tsv instead of "adl://adlacicd.azuredatalakestore.net/Samples/data/SearchLog.tsv" and its successfully gettting deployed. – Arun S
Great! I post an answer that you can accept it as answer (To mark an answer as accepted, click on the check mark beside the answer to toggle it from greyed out to filled in). – starian chen-MSFT

1 Answers

2
votes

Using relative path instead: /Samples/data/SearchLog.tsv.