Implementing a Data Lake Analytics U-SQL activity

Azure Data Lake Analytics is an on-demand analytics service that allows you to process data using R, Python, and U-SQL without provisioning any infrastructure. All we need to do is to upload the data onto Data Lake, provision the Data Lake Analytics account, and run U-SQL to process the data.

In this recipe, we'll implement a Data Lake Analytics U-SQL activity to calculate total sales by country from the orders data stored in the Data Lake store.

Getting ready

To get started, do the following:

1. Log in to https://portal.azure.com using your Azure credentials.
2. Open a new PowerShell prompt. Execute the Connect-AzAccount command to log in to your Azure account from PowerShell.
3. You will need an existing Data Factory account. If you don't have one, create one by executing the ~/azure-data-engineering-cookbook\Chapter04\3_CreatingAzureDataFactory.ps1 PowerShell script.

How to do it…

Let&apos...