Get started with Azure Data Lake Analytics using Azure portal

  • 2 minutes to read
  • Contributors

Learn 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. For more information about Data Lake Analytics, see Azure Data Lake Analytics overview.

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 a Data Lake Store 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 Store: Follow the instruction to create a new Data Lake Store 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 Store 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, click New Job.
  2. Paste in the text of the U-SQL script shown above.
  3. Click Submit Job.
  4. Wait until the job status changes to Succeeded.
  5. If the job failed, see Monitor and troubleshoot Data Lake Analytics jobs.
  6. Click the Output tab, and then click data.csv.

See also