Get started with Azure Data Lake Analytics using the Azure portal

  • 2 minutes to read
  • Contributors

This article describes how to use the Azure portal to create Azure Data Lake Analytics accounts, define jobs in U-SQL, and submit jobs to the Data Lake Analytics service.

Prerequisites

Before you begin this tutorial, you must have an Azure subscription. See Get Azure free trial.

Create a Data Lake Analytics account

Now, you will create a Data Lake Analytics and an Azure Data Lake Storage Gen1 account at the same time. This step is simple and only takes about 60 seconds to finish.

  1. Sign on to the Azure portal.
  2. Click Create a resource > Data + Analytics > Data Lake Analytics.
  3. Select values for the following items:
    • Name: Name your Data Lake Analytics account (Only lower case letters and numbers allowed).
    • Subscription: Choose the Azure subscription used for the Analytics account.
    • Resource Group. Select an existing Azure Resource Group or create a new one.
    • Location. Select an Azure data center for the Data Lake Analytics account.
    • Data Lake Storage Gen1: Follow the instruction to create a new Data Lake Storage Gen1 account, or select an existing one.
  4. Optionally, select a pricing tier for your Data Lake Analytics account.
  5. Click Create.

Your first U-SQL script

The following text is a very simple U-SQL script. All it does is define a small dataset within the script and then write that dataset out to the default Data Lake Storage Gen1 account as a file called /data.csv.

@a  = 
    SELECT * FROM 
        (VALUES
            ("Contoso", 1500.0),
            ("Woodgrove", 2700.0)
        ) AS 
              D( customer, amount );
OUTPUT @a
    TO "/data.csv"
    USING Outputters.Csv();

Submit a U-SQL job

  1. From the Data Lake Analytics account, select New Job.
  2. Paste in the text of the preceding U-SQL script. Name the job.
  3. Select Submit button to start the job.
  4. Monitor the Status of the job, and wait until the job status changes to Succeeded.
  5. Select the Data tab, then select the Outputs tab. Select the output file named data.csv and view the output data.

See also