Create a Schema and table in Azure Data Lake Database
To create a Schema and table in Azure Data Lake, first you must have a database.
You can create a database and if you do not know how to create one, you can refer the post Create Database in Azure Data Lake.
Lets create a schema and tables in Azure data lake database.
Go to Home page, select ResourceGroup under that click on Data Lake Analytics Account, here we have an account named as azuredatalakeacc.
Next click on New Job.
After that, a New Job page opens, next specify a name for jobs, named as createtable.
In code editor, now we will write a U-SQL Scripts that creates a schema named as Stud, and a table named as studentInfo under the schema in Database Db_Live.
USE DATABASE Db_live; CREATE SCHEMA IF NOT EXISTS Stud; CREATE TABLE Stud.StudentInfo ( StudID int, StudName string, StudAddress String, RegDate DateTime, INDEX idx_StudID CLUSTERED(StudID ASC) DISTRIBUTED BY HASH(StudID) );
2,057 total views, 7 views today