filmov
tv
Data Factory Tutorial - How to create your first pipeline
![preview_player](https://i.ytimg.com/vi/0ZHo25FaK0Y/maxresdefault.jpg)
Показать описание
Learn how to create your first pipeline in Azure Data Factory in this Data Factory Tutorial. I explain how to copy data from Data Lake Storage into an SQL Database. In the video I talk through how to setup Data Factory, configure linked services and datasets and finally the pipeline.
If you would like to follow along with the video you can copy and paste the below in to a file and save as CSV:
Firstname,Lastname,DOB
Tony,Fellows,19/07/1984
Christine,Burt,25/02/1967
Patricia,Martins,07/12/1979
Scripts to grant Data Factory access to SQL Database:
-- create login in master database
CREATE LOGIN [datafactory] WITH PASSWORD = 'd4t4f4ctory123!';
GO
-- create user in database
CREATE USER [datafactory];
GO
-- add user to role in database
ALTER ROLE db_owner ADD MEMBER [datafactory];
GO
-- create target table
CREATE TABLE dbo.Customers
(
FirstName VARCHAR(50) NULL,
LastName VARCHAR(50) NULL,
DOB VARCHAR(50) NULL
);
-- query table
SELECT
*
FROM dbo.Customers;
If you would like to follow along with the video you can copy and paste the below in to a file and save as CSV:
Firstname,Lastname,DOB
Tony,Fellows,19/07/1984
Christine,Burt,25/02/1967
Patricia,Martins,07/12/1979
Scripts to grant Data Factory access to SQL Database:
-- create login in master database
CREATE LOGIN [datafactory] WITH PASSWORD = 'd4t4f4ctory123!';
GO
-- create user in database
CREATE USER [datafactory];
GO
-- add user to role in database
ALTER ROLE db_owner ADD MEMBER [datafactory];
GO
-- create target table
CREATE TABLE dbo.Customers
(
FirstName VARCHAR(50) NULL,
LastName VARCHAR(50) NULL,
DOB VARCHAR(50) NULL
);
-- query table
SELECT
*
FROM dbo.Customers;
Azure Data Factory | Azure Data Factory Tutorial For Beginners | Azure Tutorial | Simplilearn
Azure Data Factory Beginner to Pro Tutorial [Full Course]
Azure Data Factory Tutorial | Introduction to ETL in Azure
Azure Data Factory Mapping Data Flows Tutorial | Build ETL visual way!
Azure Data Factory | Azure Data Factory Tutorial For Beginners | Introduction to Azure Data Factory
Azure Data Factory Self-hosted Integration Runtime Tutorial | Connect to private on-premises network
What is the Azure Data Factory? | How to Use the Azure Data Factory
1. Introduction to Azure Data Factory
Exploring AI Capabilities: GPT-4, Azure OpenAI, & Microsoft Fabric by Alpa Buddhabhatti | #Data...
3. Create your First Azure Data Factory
Process Excel files in Azure with Data Factory and Databricks | Tutorial
Azure Data Factory Part 1 - Introduction about Azure Data Factory
Azure Data Factory Parametrization Tutorial
Azure Data Factory | Moving On-Premise Data to Azure Cloud | Microsoft Azure Training | Edureka
Azure Data Factory Triggers Tutorial | On-demand, scheduled and event based execution
Azure Data factory Training | Microsoft Azure Data Factory Course | Intellipaat
Azure Data Factory | Azure Data Factory Tutorial | Azure Data Engineer | Intellipaat
6. Linked Services and Datasets in Azure Data Factory
Azure Data Factory Part 4 - Integration Run Time and Different types of IR
Azure Data Factory | Copy multiple tables in Bulk with Lookup & ForEach
Azure Data Factory v2 Tutorial for Beginners
Azure Data Factory Part 3 - Creating first ADF Pipeline
5. Pipelines and Activities in Azure Data Factory
Building Data Flows in Azure Data Factory
Комментарии