Azure Data Factory: Generate Pipeline from the new Template Gallery

Loading view.

Events Search and Views Navigation

Search

Enter Keyword. Search for Events by Keyword.

Find Events

Event Views Navigation

List

List

Month

Day

Today

2023-10-09

October 9, 2023

-

2024-05-16

May 16

Select date.

October 2023

Mon

9

Featured

Featured

October 9, 2023 @ 8:00 am - October 10, 2023 @ 5:00 pm CEST

DataMinds Connect 2023

Congres- en Erfgoedcentrum Lamot

Van Beethovenstraat 8-10, Mechelen, Belgium

Mon

9

Featured

Featured

October 9, 2023 @ 8:00 am - October 11, 2023 @ 5:00 pm CEST

Techorama NL 2023

Kinepolis Jaarbeurs Utrecht

Jaarbeursboulevard 300, Utrecht, Utrecht, Netherlands

November 2023

Tue

14

Featured

Featured

November 14, 2023 - November 17, 2023

Ignite

International Convention Centre

Celtic Manor, , Wales NP18 1HQ, Newport, South Wales

Tue

14

November 14, 2023 - November 18, 2023

Pass Data Community Summit

Washington State Convention Center

705 Pike Street, Seattle, WA, United States

February 2024

Thu

8

February 8

Fabric February

Microsoft Norway,

Dronning Eufemias gate 71, Oslo, Norway

March 2024

Tue

19

March 19

SQLBits Training Day

Farnborough International Ltd,Show Centre

P S Rd, Farnborough, Farnborough, United Kingdom

Wed

20

March 20 - March 23

SQL Bits General Sessions

Farnborough International Ltd,Show Centre

P S Rd, Farnborough, Farnborough, United Kingdom

Sun

24

Featured

Featured

March 24 - March 30

Microsoft Fabric Community Conference

MGM Las Vegas

3799 S. Las Vegas Blvd., Las Vegas, Nevada, Nevada, United States

May 2024

Tue

14

Featured

Featured

May 14 @ 8:00 am - May 15 @ 5:00 pm CEST

SQL Day 2024

Centennial Hall

Wroclaw, Poland

Thu

16

Featured

Featured

May 16 @ 8:00 am - May 17 @ 5:00 pm CEST

DataGrillen

IT Zentrum Lingen

Kaiserstraße 10b, Lingen, Germany

Previous Events

Today

Next Events

Subscribe to calendar

Google Calendar

iCalendar

Outlook 365

Outlook Live

Export .ics file

Export Outlook .ics file

Read More

Collection of all ADF Mapping Data Flow videos

SQLBits Training Day

ADF Mapping Flow

Did you use the Dataflow preview functionality in Azure Data Factory? This has recently be renamed to Mapping Data Flows.
 

All video’s which the ADF team has created, are collected.
Start Here:

ADF Data Flow: Overview
ADF Data Flow: Data Flow Scenarios
ADF Data Flows: Getting started
Getting started with ADF Data Flows from Altius
Getting started with Mapping Data Flows by Adam from Azure 4 Everyone

Debug and Prep:

ADF Data Flow: Debug Session, Pt 1
ADF Data Flow: Debug Session, Pt 2 Data Prep
ADF Data Flow: Debug and Test Lifecycle
Mapping and Wrangling: Data Exploration
Debug and testing End-to-End in Mapping Data Flows
Data Masking for Sensitive Data
Benchmark Timings
Dynamically optimize data flow cluster size at runtime

Transformations:

ADF Data Flows: Joins
ADF Data Flows: Pivot Transformation
ADF Data Flows: Window Transformation
ADF Data Flows: Alter Row Transformation
ADF Data Flows: Surrogate Key Transformation
ADF Data Flows: Lookup Transformation
ADF Data Flows: Aggregate Transformation
ADF Data Flows: Derived Column Transformation
ADF Data Flows: Union Transformation
ADF Data Flows: Unpivot Transformation
ADF Data Flows: Exists Transformation
ADF Data Flows: Filter Transformation
ADF Data Flows: Conditional Split Transformation
ADF Data Flows: Select and New Branch
ADF Data Flows: Flatten Transformation
ADF Data Flow Sources: CosmosDB
Fuzzy Lookups
Quick Transformations
Drifted Columns using Pivot
Source & Sink Transformations: Partitioned Files
ADF Data Flows: New Datasets Parquet and Delimited Text
JSON Transformations
Infer Data Types
Dynamic Joins and Lookups

Optimize:

ADF Data Flow: Monitoring UX
ADF Data Flow: Data Lineage
ADF Data Flow: Optimize Data Flows
ADF Data Flow: Iterate files with parameters
ADF Data Flow: Decrease start-up times
ADF Data Flow Perf: SQL DB
Optimize compute environment

Patterns:

ADF Data Flow: Staging Data Pattern
ADF Data Flow: Clean Addresses Pattern
ADF Data Flow: ETL DW Load Pattern
ADF Data Flow: Deduplication of your Data
ADF Data Flow: Merge Files
ADF Data Flow: SCD Type 1 Overwrite
ADF Data Flow: SCD Type 2 History
ADF Data Flow: Fact Table Loading
ADF Data Flow: Logical Models
ADF Data Flow: Detect source data changes
ADF Data Flow: Schema Drift Handling
Flexible Schema Handling with Schema Drift
ADF Data Flow: Parameters
Transform SQL Server on-prem with delta data loading pattern
SCD Type 1 and Type 2 demo by Bob Rubocki
Rule-based Mapping
Distinct Row & Row Counts
Handling truncation errors
Partition your files in the data lake
Intelligent data routing
Transform and Create Multiple Tables
Data Quality Patterns
Self-join patterns
Data lake file output options
Evolving database schema handling

Expressions:

Date/Time expressions
Split Arrays and Case Statement
Fun with string interpolation and parameters
Data Flow Script Intro: Copy, Paste, Snippets
Data Quality Expressions
Collect aggregate function

 
Do you want to know more or you want to try out some examples, you can find them here

Feel free to leave a comment

Proud to be an ADF Hackathon winner!

Azure Data Factory HackathonAround the clock During the event 'Around the clock Azure SQL and Azure Data Factory' event on Feb 3, 2021, they kicked-off the Azure Data Factory (ADF) Hackathon. Recording of this event can be found here.Winner I submitted a ADF Pipeline...

10 Days of Azure Synapse Analytics

10 Days of Azure Synapse AnalyticsFor the next 10 days, every day a different topic is explained about Azure Synapse Analytics. The shortest and easiest way to see how Azure Synapse Analytics can help you, to make decisions within your data landscape.Day 1...

Yeah My website is Finally Live

Yeah, my first built website is LIVEThe last couple of weeks I've been working hard to design my website and finally the moment is there. My website live and I'm really proud.  Building my own website The last couple of weeks/months I've been working hard... to...

Restore a accidentally deleted Azure SQL Database

Help I deleted my Logical Server​OOPS Have you ever experienced that you accidentally deleted your Logical Server in Azure?  Because, for example, you made your Pipeline wrong. Surely. And of course you didn't have a backup in your storage either.Well I must confess...

Azure Data Factory: New functionalities and features

New functionalities and featuresLast week, a number of great new functionalities and features were added within Azure Data Factory. I would like to take you in some details in the blog below:Customer key With this new functionality you can add extra security to your...

Azure Synapse Analytics

Azure Synapse Analytics  Insights for all Azure Synapse provides a breathtaking view of your data across data warehouses and big data analytics systems. Bringing these two worlds together into a single service is challenging as it requires unifying similar...

Control my Nest Thermostat on my Domoticz Server running on a Synology DiskStation

Control your Nest Thermostat  in DomoticzNormally I always write Azure related, but today I'm writing about something different, on how I can control my Nest Thermostat on my Domoticz Server (Home automation). A while ago I have upgraded my  Nest Thermostat to login...

My First Blog Post SQLSatHolland 790

Yeah, my first blog is LIVEAfter a good talk with Reza Rad from RADACAD during SQLSatHolland, I decided to start my first blog!Knowledge sharing is very important, it gives me a lot of energy. But it also gives others people in the community energies to pick up new...

New Microsoft Azure Certifications

Microsoft Certification by Solution Area Handy overview of the new Microsoft Azure Certifications. More details can be found here Feel free to leave a comment

How to use concurrency in Azure Synapse pipelines?

How to prevent concurrent pipeline execution?Concurrency This week I had a discussion with a colleague about how we can now make sure that a Pipeline does not start when it's already started. He then indicated, have you ever thought of the concurrency option?  I've...

Read More

Azure DevOps and Azure Feature Pack for Integration Services

SQLBits Training Day

Azure Feature Pack for Integration Services

Azure Blob Storage
A great addition for SSIS is using extra connectors like  Azure Blob Storage or Azure Data Lake Store which are added by the Azure Feature Pack. This Pack needs to be installed on your local machine. Are you running your SSIS packages in Azure?  You don’t have to install anything, this pack is installed by default.

 

 

Building your SSIS Packages in Azure DevOps
After I started to use Azure Dev Ops to build my SSIS packages on a hosted VS2017, I got some strange error messages running these packages.

Microsoft Support
After contacting support we found out that the Azure Feature Pack is not installed on a Hosted VS2017 instance and that you need to add this installation to your build processes.
 
Install Azure Feature Pack on your Hosted VS2017 machine
Follow the steps to download and install the Azure Feature Pack:

Open  your dev.azure.com/instance.
Create a new Build Pipeline or use an existing one.
Select the correct Sources and after that you can add a new build task.
Add a Powershell Task.

This task needs to be added before the build process of your SSIS project.

Define the Display name “Install Azure Feature Pack”.
Type => Inline.
Add the script which you can find below.
Save and Queue the Pipeline.
Check the Results.

 

Powershell script
The script will take care of downloading and installing the Azure Feature Pack for SSIS2017 on your hosted 2017 machine.
The File SsisAzureFeaturePack_2017_x64.msi will be downloaded to the system variable Build.StagingDirectory.
Inline script:
[code lang="ps"]
# Erwin de Kreuk
# February 2019
# PURPOSE: Install Azure Feature pack on Hosted VS2017 machine in Azure DevOps

Write-Information 'Starting ADF ARM Transform'

#Define Filename
$Filename = 'SsisAzureFeaturePack_2017_x64.msi'
$Arguments=' /qn'
Write-Host 'Downloading...$Filename'
#Define download link including filename and output directory with filename
Invoke-WebRequest -Uri 'https://download.microsoft.com/download/E/E/0/EE0CB6A0-4105-466D-A7CA-5E39FA9AB128/SsisAzureFeaturePack_2017_x64.msi' -OutFile '$(Build.StagingDirectory)\$Filename'

Write-Host 'Installing...$Filename'
Invoke-Expression -Command '$(Build.StagingDirectory)\$Filename $Arguments'
Write-Host 'Finished Installing...$Filename'

[/code]

The next time you build your SSIS Packages with the Azure Components, these packages are build correctly. Create a Release Pipeline to Deploy the SSIS Packages to the SSIS server and to test your Package.
Thanks for reading today and if there’re some questions left do not hesitate to ask them.

Latest Posts
How to use mssparkutils.notebook.runMultiple in Notebooks in Microsoft Fabric?
Video: Learn Live Use Data Factory pipelines in Microsoft Fabric
How to use the PySpark executor in Notebooks in Microsoft Fabric?
High Concurrency Notebook Activity in Microsoft Fabric
Data Community Austria

Feel free to leave a comment

Read More

Are you using Azure DevOps?

SQLBits Training Day

Azure DevOps

More and more users are starting with Azure DevOps. Azure DevOps can be used for up to 5 users free of charge and is therefore a great start to start a project.
 
 

Build and Release
I will not describe what Azure DevOps can do, because that is too much to mention. In my future articles I want to take you into the challenges that I had in my projects during building and releasing of f.e. DataFactory, SSIS Packages, KeyVault, a number of recognizable Azure Services that are regularly used within Business Analytics projects.
If you want to use Azure Feature Pack components like Azure Blob Storage or Azure Data Lake Store  in your SSIS Packages, I would definitely read the following article:
Azure DevOps and Azure Feature Pack for Integration Services

Feel free to leave a comment

SQLBits session: Microsoft Purview Data Policy App

SQLBits 2023 Thanks everyone for visiting my session during SQLBits. It's great to see such a full room and that so many people have started using Microsoft Purview.  SLIDES The slides can be downloaded via the link below, so that you can view them again at...

Azure Purview MSIgnite Spring 2021 Announcements

Azure Purview Ignite 2021 AnnoucementPricing This week the Azure Purview announced that they will extend the Azure Purview offer to provision 4 Capacity Units of the Data Map for free till May 31, 2021! Charging will start on June 1, 2021. Great news for customer who...

Azure Synapse Analytics Code Repository has arrived

Azure Synapse Analytics Code repository‎I just opened my Azure Synapse Analytics Workspace and got a great surprise, the option Git Configuration is available as of today‎.    After a long wait, today the Git Configuration option became available in Azure Synapse...

Service Health Alerts in Azure

Maintenance and Service Healths in AzureI get often questions, is there no maintenance in Azure. Like every data center, the Azure data center also needs maintenance. You can even be notified when a specific service, in a specific data center, has scheduled...

Working from Home: How do I get my energy and focus back on track?

Working from home It has now been exactly 7 weeks since I started working from home. In the beginning this went with full energy, but now gradually the energy and the focus on the work is starting to drain.I'm the only one in here? I'm sure, I'm not. I regularly hear...

Custom comments in Azure Synapse Analytics

Add custom comments to your Azure DevOps and Github commitsFinally ​Finally and secretly hidden, we can now add a Comment to our commits in Azure Synapse Analytics and Azure Data Factory to Azure Dev Ops. How do you activate this custom comment option in your existing...

Azure Purview Public Preview Starts billing

Billing for Azure Purview(Public Preview)As of January 20th 2021 0:00 UTC Azure Purview will starts billing.Preview From January 20 ,2021 Azure Purview will start billing. During the Public Preview, you will only be billed if you exceed the 4 capacity units for Azure...

Azure Purview March Updates

Azure Purview updatesAnnouncements Last week during SQLBITS, quite a few new updates were announced. I would like to include you in these announcements.March updates Support for SAP Business Warehouse (Preview) Blogpost:...

Calculate the Last Day of the Month using SQL

Calculate the Last DayToday I needed to calculate the last day of the previous month for a Customer.Ever heard from the function EOMONTH? Searching on the web I came across a function I never heard from before EOMONTH, this function can be used as of SQL Server 2012....

Goodbye 2021, Hello 2022

Goodbye 2021Recap First of all, I would like to wish everyone a very beautiful and healthy 2022. We are now 3 days on the road into the new year and it is always good to look back at what happened last year. It's certainly been an eventful year, topped off with my MVP...

Read More

Rerun Pipeline activities in Azure Data Factory

SQLBits Training Day

Rerun Pipeline activities in ADF!

As of today you can rerun or partially, yes you’re reading it correct partially, rerun you Azure Data Factory pipeline.Where you previously had to run the entire Pipeline again, you can now run a part of the Pipeline. This can save a lot of time if many different activities are created within one pipeline. Another nice step forward, I’m curious what else is coming in the next months.
 

Visualized
Besides that you can rerun your Pipeline in Azure Data Factory in a easy way, you also have the possibilities to see your run,  visualized in the Azure Data Factory Monitoring. This is a big improvement in my opinion.

Rerun a Pipeline
If you want to partially rerun a Pipeline, follow the steps below:Select the Pipeline which has failed, go to the view activity runs and select the activity which failed.
Click on the Rerun Icon

 
 
 
 
You need to confirm that you want to rerun this activity.

The Pipeline will start and will first skip all the activities(the grey new icons in the upper right corner of each activity) in the Pipeline before your selected Activity.Your Pipeline will now finalize all the activities from your newly defined starting point.

 
What else is new?
Monitor Rerun History
You can now view all the history reruns by clicking on the toggle to ‘View All Rerun History’.

By clicking on the red marked action, you can see all the History from an particular Pipeline run.

 
Thanks for reading.
 
 
Updated 10th of March:
 
Found a video on Channel9 which explains how to  “Rerun activities inside your Azure Data Factory pipelines”
https://channel9.msdn.com/Shows/Azure-Friday/Rerun-activities-inside-your-Azure-Data-Factory-pipelines?ocid=player

Feel free to leave a comment

How to enable Microsoft Fabric

Microsoft FabricI got some questions from customers that didn’t know how to enable Microsoft Fabric and that they only see Power BI Items and not the new announced Experiences. In this short blog I will explain how you can easily enable Microsoft Fabric.How to enable...

Book of News Microsoft Ignite 2019

Microsoft Ignite 2019MSIgnite 2019 has almost come to an end. A lot of new Annoucement have been released and presented.  Would you also like to know which announcements have been made?Microsoft has released during MSIgnite a "Book of News". This book contains all new...

Goodbye 2021, Hello 2022

Goodbye 2021Recap First of all, I would like to wish everyone a very beautiful and healthy 2022. We are now 3 days on the road into the new year and it is always good to look back at what happened last year. It's certainly been an eventful year, topped off with my MVP...

Restore a accidentally deleted Azure SQL Database

Help I deleted my Logical Server​OOPS Have you ever experienced that you accidentally deleted your Logical Server in Azure?  Because, for example, you made your Pipeline wrong. Surely. And of course you didn't have a backup in your storage either.Well I must confess...

Azure Purview MSIgnite Spring 2021 Announcements

Azure Purview Ignite 2021 AnnoucementPricing This week the Azure Purview announced that they will extend the Azure Purview offer to provision 4 Capacity Units of the Data Map for free till May 31, 2021! Charging will start on June 1, 2021. Great news for customer who...

Calculate the Last Day of the Month using SQL

Calculate the Last DayToday I needed to calculate the last day of the previous month for a Customer.Ever heard from the function EOMONTH? Searching on the web I came across a function I never heard from before EOMONTH, this function can be used as of SQL Server 2012....

Custom comments in Azure Synapse Analytics

Add custom comments to your Azure DevOps and Github commitsFinally ​Finally and secretly hidden, we can now add a Comment to our commits in Azure Synapse Analytics and Azure Data Factory to Azure Dev Ops. How do you activate this custom comment option in your existing...

My First Blog Post SQLSatHolland 790

Yeah, my first blog is LIVEAfter a good talk with Reza Rad from RADACAD during SQLSatHolland, I decided to start my first blog!Knowledge sharing is very important, it gives me a lot of energy. But it also gives others people in the community energies to pick up new...

10 Days of Azure Synapse Analytics

10 Days of Azure Synapse AnalyticsFor the next 10 days, every day a different topic is explained about Azure Synapse Analytics. The shortest and easiest way to see how Azure Synapse Analytics can help you, to make decisions within your data landscape.Day 1...

High Concurrency Notebook Activity in Microsoft Fabric

Microsoft Fabric is a cloud-based platform that provides integrated data engineering and data science solutions. One of the key features of Microsoft Fabric is the support for Apache Spark, a distributed computing framework that enables large-scale data processing and...

Read More

Upcoming Events