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