Jaa


Get started with Azure Data Lake Analytics using the Azure portal

Important

New Azure Data Lake Analytics accounts can no longer be created unless your subscription has been enabled. If you need your subscription to be enabled contact support and provide your business scenario.

If you are already using Azure Data Lake Analytics, you'll need to create a migration plan to Azure Synapse Analytics for your organization by February 29th, 2024.

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. If you don't, you can follow this link to get an Azure free trial.

Create a Data Lake Analytics account

Now, you'll 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. Select Create a resource, and in the search at the top of the page enter 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. Select Create.

Your first U-SQL script

The following text is a 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