Skip to main content

Azure DataLake

Azure DataLake 

Azure DataLake is microsoft's big data platform and is very similar to other distributed processing and storage system like hadoop or google bigquery. 
DataLake has two different part 
  • DataLake Store - Platform that provides unstructured storage (file storage, any format)
  • DataLake Analytics - This can have the structure storage which is ready for running structured query like SQL. We use USQL to query DataLake.

Steps to create DataLake Store

  • Login to Azure Portal
  • Click on +new from left top menu.
  • Select Data+Analytics and you will get list.
  • Click on Azure Data Lake Store
  • Fill in all the required details in the new window as shown below and click on create.

Setting up user permission for DataLakeStore

From all resource menu click on the newly created DataLake store.
On the menu click on Access control and select user and group from AD to provide necessary access as shown below.
To provide access to users to upload files and data follow the below step
  • Once you click on the given datalake store on the menu click on the Data Explorer option.
  • You will get a new window where click on Access and add required users provide different types of accesses like read, write, execute etc.
You can use the web URL and ADL URI to upload files and data using web interface or any application or ETL package like SSIS.



  

Comments

  1. UnknownJuly 6, 2018 at 3:19 PM

    Nice article, Thanks for providing your information. Get more knowledge on Azure with Azure Online Course

    ReplyDelete

Post a Comment

Popular posts from this blog

DataZen Syllabus

INTRODUCTION TO DATAZEN PRODUCT ELEMENTS ARCHITECTURE DATAZEN ENTERPRISE SERVER INTRODUCTION SERVER ARCHITECTURE INSTALLATION SECURITY CONTROL PANEL WEB VIEWER SERVER ADMINISTRATION CREATING AND PUBLISHING DASHBOARDS CONNECTING TO DATASOURCES DESIGNER CONFIGURING NAVIGATOR CONFIGURING VISUALIZATION  PUBLISHING DASHBOARD WORKING WITH MAP  WORKING WITH DRILL THROUGH DASHBOARDS
67 comments
Read more

PowerBI Interview Questions and Answers

Power BI Interview Questions – General Questions 1). What is self-service business intelligence? Ans: Self-Service Business Intelligence (SSBI) is an approach to data analytics that enables business users to filter, segment, and, analyse their data, without the in-depth technical knowledge in statistical analysis, business intelligence (BI). SSBI has made it easier for end users to access their data and create various visuals to get better business insights. Anybody who has basic understanding of the data can create reports to build intuitive and shareable dashboards. 2). What are the parts of Microsoft self-service business intelligence solution? Ans: Microsoft has two parts for Self-Service BI  Excel BI Toolkit – It allows users to create interactive report by importing data from different sources and model data according to report requirement.  Power BI – It is the online solution that enables you to share the interactive reports and queries that you have created using ...
7 comments
Read more

MS BI Syllabus

Microsoft Business Intelligence Course Syllabus SSRS – SQL Server Reporting Services  Getting Started 1. Understanding Reporting (Authoring,Management,Delivery) 2. Installing Reporting (Native Mode, SharePoint Integration mode) 3. Building your first report  Authoring Reports 1. Developing Basic Reports (RDL,wizard,designer,datasource,dataset,formatting) 2. Working with expressions (expression to calculate value, Agg functions, exp for objects) 3. Organizing Data (Data Regions, Table, Matrix, Chart, List) 4. Advance Report (Parameter, drill down, drill through, links, 5. Report Model (Data Source, Data Source View, Model , Report Builder 3.0)  Managing Report ( Report Manager) 1. Managing Content (deploying report, folders, linked reports, datasources, value etc) 2. Managing Security (Item Level , Site navigation, localhost – sql) 3. Managing Server Config (Config Manager, Report Manager, Report Server DB)  Delivering Report 1. Accessing Report (Viewing...
30 comments
Read more