Understanding how to create a storage blob in Azure. Steps to create a new storage account. Sign in to the Azure portal at https://portal.azure.com Select Create a resource. Under Categories, s...

In this task, we are going to remove duplicates from a csv file present in a container. Open data factory 1. Create linked service to blob storage 2. Create datasets for source and sink 3. Cr...

In this task, we are going to configure Azure Data Flow Error Handling. We have 2 containers in our storage account bad-records demo-data Inside demo-data, we have a csv file “People.csv” ...

In this task, we are going to use derived columns transformation in Azure Data Factory to split a column into 2 columns. We have a container demo-data with a csv file !(/assets/img/posts/dataflow...

In this task, we are going to use conditional split in Azure Data Factory to split the data in a Persons table present in Azure SQL Database to split the data based on the age column. Persons who ...

In this task, we are going to flatten the json file stored in a Container in our storage account. In the json file, the data is an array of arrays, so we are going to flatten it to individual reco...

Understanding how to enable security for Azure Data Lake. The security model in Azure Data Lake Storage supports both RBAC and ACLs. Azure role assignments are evaluated first. They take priority ...

Understanding how to configure a hierarchical namespace for Azure Data Lake. 1. Create a storage account Enable the hierarchical namespace to create a Data Lake Quick question: You plan t...

Understanding how to create a resource lock in Azure. Configure a resource lock Task 1: Create a resource Create a storage account. Setting Value Reso...

In this exercise, you use the Pricing calculator to estimate the cost of running a basic web application on Azure. Define your requirements For a basic web application hosted in your datacenter, y...