CODEWITHSUNDEEP
azure-data-lakeu-sqlazure-pipelines-release-pipeline
Arun S
Arun S

Reputation: 1453

Azure U-SQL Continous deployment using VSTS Powershell task

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://learn.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.

Upvotes: 0

Views: 119

Answers (1)

starian chen-MSFT
starian chen-MSFT

Reputation: 33698

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

Upvotes: 2

Related Questions