How can i connect to Azure Data Lake Analysis with Azure Blob Storage

Question

Hi i analyze system log using Azure Data Lake Analysis.

And, i meet a problem that connect Blob Storage from Data Lake Analysis(U-SQL)

This U-SQL shows that read file from blob storage

Before launching this U-SQL, I create test2 blob storage and testcon container

(and set access policy)

@searchlog = 
EXTRACT UserId          int, 
        Start           DateTime, 
        Region          string, 
        Query           string, 
        Duration        int, 
        Urls            string, 
        ClickedUrls     string
FROM @"wasb://testcon@test2/SearchLog.tsv"
USING Extractors.Tsv();

But i meet a exception.

Error
E_STORE_USER_FAILURE

Message
Secret not found for the specified user account Cosmos Path: wasb://testcon@test2/SearchLog.tsv

How can i solve this problem?

Answer 1

Ensure that your Windows Azure Blob Storage account is registered with your Azure Data Lake Analytics account. I have copied the steps below from Registering Your Windows Azure Blob Storage account.

1. Navigate to the Azure Portal and log in.
2. Navigate to your Azure Data Lake Analytics Account.
3. Select Data Sources under Settings.
4. Verify whether your WABS account is listed. If yes, stop here. If no, continue to next step.
5. Click Add Data Source.
6. Select Azure Storage from the Storage Type drop-down list.
7. Select Select Account from the Selection Method drop-down list.
8. Select your WABS account from the Azure Storage drop-down list.
9. Click Add.