Get started with Azure Data Lake Analytics using the Azure portal
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.
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.
- Sign on to the Azure portal.
- Click Create a resource > Data + Analytics > Data Lake Analytics.
- 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.
- Optionally, select a pricing tier for your Data Lake Analytics account.
- 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
@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
- From the Data Lake Analytics account, select New Job.
- Paste in the text of the preceding U-SQL script. Name the job.
- Select Submit button to start the job.
- Monitor the Status of the job, and wait until the job status changes to Succeeded.
- Select the Data tab, then select the Outputs tab. Select the output file named
data.csvand view the output data.
- To get started developing U-SQL applications, see Develop U-SQL scripts using Data Lake Tools for Visual Studio.
- To learn U-SQL, see Get started with Azure Data Lake Analytics U-SQL language.
- For management tasks, see Manage Azure Data Lake Analytics using Azure portal.