Azure is a cloud computing service created by Microsoft for building, testing, deploying, and managing applications and services through Microsoft-managed data centers.
Implementing a Pivot Transformation Using Data Flow Activity – Azure Data Factory Using Azure Data Factory you can create a data flow for Pivot transformation.… Read More »Azure Data Factory Pivot Transformation Using Data Flow
According to Microsfot, Azure Data Factory is Azure’s cloud ETL service for scale-out serverless data integration and data transformation. It offers a code-free UI for intuitive authoring and single-pane-of-glass monitoring and management.
Create Azure SQL Database
Microsoft Azure SQL Database is a managed cloud database provided as part of Microsoft Azure. A cloud database is a database that runs on a cloud computing platform, and access to it is provided as a service. It gives a high performance without having to worry about any infrastructure.
Create Azure SQL Database Server To Create an Azure SQL Database Server, Go to Home Page then search for SQL Servers in Search bar, click… Read More »Create Azure SQL Database Server
Create Azure Data Factory
The Azure Data Factory service is a fully managed service for composing data storage, processing, and movement services into streamlined, scalable, and reliable data production pipelines
Loading a Data from Azure Data Lake Storage to Azure Data Lake Database requires an azure data lake storage. So you must have a file… Read More »Load Data from Azure Data Lake Storage to Azure database
Create a Schema and table in 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.
Upload Files to Azure Data Lake Storage You can upload files to Azure Data Lake Storage using Azure Portal or Azure Storage Explorer. Here we… Read More »Upload files to Azure Data Lake Storage
Create a Azure Data Lake Storage Account
Microsoft Azure Data Lake is a highly scalable public cloud service that allows users to gain insight from large, complex data sets.
Load Files from Blob Storage to Azure SQL Server Database
Azure storage account is used to store azure storage data objects such as blobs, files, queues, tables, and disks.
