Home » Create an Azure Data Lake Database

Create an Azure Data Lake Database

Create an Azure Data Lake Database




 

Azure Data Lake Analytics comes with a catalog that comes with a Master Database, you can also create your own database.

Before creating a Azure Data Lake Database, first you must have an Azure Data Lake Analytics account, and to process data in Azure Data Lake Analytics, you need an Azure Data Lake Analytics account and associate it with an Azure Data Lake store, if you do not know how to create an azure Data lake analytics account, you can refer the post – Create an Azure Data Lake Analytics account.

Lets create an Azure Data Lake Database.

Go to Home page, select ResourceGroup under that ResourceGroup click on Data Lake Analytics Account, here we have azuredatalakeacc.

 

 

After that, New Job page opens, next specify jobs name, that is createDatabase.

In code editor, we will write a U-SQL Scripts that creates a database named as Db_live.

 

CREATE DATABASE IF NOT EXISTS Db_live;

 

After clicking on submit button, you will get a status as succeeded, if job executed successfully.





 

Now go into your Catalog, and check for database that you created.

Go to your Data Lake Analytics account, and click on Data Explorer.

 

 

 

Once you click on Data Explorer, a Data Sources page opens, then click on Catalog there you can see the database db_live that you created.

Also Read..

Create an Azure Data Lake Analytics Account

Upload Files to Azure Data Lake Storage




SQL Basics TutorialSQL Advance TutorialSSRSInterview Q & A
SQL Create tableSQL Server Stored ProcedureCreate a New SSRS Project List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLESQL Server MergeCreate a Shared Data Source in SSRSSQL Server Question & Answer Quiz
SQL DropSQL Server PivotCreate a SSRS Tabular Report / Detail Report
..... More.... More....More
Power BI TutorialAzure TutorialPython TutorialSQL Server Tips & Tricks
Download and Install Power BI DesktopCreate an Azure storage accountLearn Python & ML Step by stepEnable Dark theme in SQL Server Management studio
Connect Power BI to SQL ServerUpload files to Azure storage containerSQL Server Template Explorer
Create Report ToolTip Pages in Power BICreate Azure SQL Database ServerDisplaying line numbers in Query Editor Window
....More....More....More

 493 total views,  3 views today

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.