Import Data In Azure Data Lakes Store

Below are the topics we will be working on in this demo,

  1. Creating an Azure Data Lake Store Account
  2. Creating an Azure Data Lake Analytics Account
  3. Importing Data into Azure Data Lake Store Account.

Technical Requirements

Microsoft Azure Subscription.

CREATING AN AZURE DATA LAKE STORE ACCOUNT

Login to the Microsoft Azure Subscription using this link.


Follow the below clicks now.

New - Intelligence + Analytics - Data Lake Store.


Complete the below details of Name, Subscription, Resource Group, Location for your Data Lake Store Account, Pricing and Encryption Settings. Click on "Create" button after configuring the above details on your Azure Portal.


Here is my Data Lake Store Account created on my Microsoft Azure Portal.


Click on "Resource Groups" in the left pane of the Microsoft Azure portal.


Click on the resource group that you created, named rgdl over here and now you can find a notification that the deployment has succeeded which means that the Data Lake Store Account has been created.


CREATING AN AZURE DATA LAKE ANALYTICS ACCOUNT

Azure Data Lake Analytics allows us to operate with a wide range of data sources that are available in the Azure Data Lake Store account. Now in this demo, I will be creating an Azure Data Lake Analytics account and connect it to the Azure Data Lake Store Account.

Open your Azure portal using this and follow the below commands.

New - Intelligence + Analytics - Data Lake Analytics

Fill in the below details now for Name of the Data Lake Analytics, Subscription, for Resource Group – select the existing resource group of which you created on the previous demo, select the same Data Lake Store which you have created before. Click on "Create" after configuring all the blades as shown below.






Now, the deployment has been completed for Azure Data Lake Analytics account.


Now, move back to the Resource Groups which you have created and check for the deployment. You can find that two deployments have succeeded.




IMPORT DATA INTO AZURE DATA LAKE STORE

Open the Azure Data Lake Store account that you created in the previous demo by clicking on it.


Click on "Data Explorer" on your Azure Data Lake Store.


Click on "Upload" option as shown below.


You should get a window for uploading your file.


Upload the TSV files that have been shared with this article by clicking on the "Open Window" icon on the pane and upload your TSV files. You can also find the uploading status with percentage as shown.


And now the files are uploaded.


Clicking on any of a file over here will list out a preview of the data that you have already uploaded.


KEYNOTES IN SHORT

  1. Creating an Azure Data Lake Store Account
  2. Creating an Azure Data Lake Analytics Account
  3. Importing Data into Azure Data Lake Store Account.