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-25

May 25

Select date.

October 2023

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

Sat

25

Featured

Featured

May 25 @ 8:00 am - 5:00 pm CEST

DATA SATURDAY STOCKHOLM

Telia head office campus

Stjärntorget 1, Stockholm, Sweden

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

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...

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...

Microsoft Fabric pricing (Preview)

Microsoft Fabric PricingMicrosoft Fabric pricing in Public Preview is announced as of the 1 st of June.These are currently the Pay as You go pricing, later this year the Azure Reservation will follow. OneLake storage pricing is comparable to Azure ADLS (Azure Data...

How to check your SQL Server Quota in Azure?

Azure Subscription Usages for SQL Server  Last week we reached our Logical server Quota in Azure. By default you're only allowed to add 20 Logical Servers, but we wanted to have some more for testing purposes.Microsoft Support You can submit a support ticket trough...

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...

Parameterize Linked Services in ADF

Parameterize Linked Services For my Azure Data Factory solution I wanted to Parameterize properties in my Linked Services. Not all properties are Parameterized by default through the UI. But there's another way to achieve this.    Linked Service Open your existing...

My Sessions at DataSaturdayNL 2019

DataSaturday NL 2019Date: 5 th October Location: Pathé Leidsche Rijn Data Saturday Holland is the new name for SQL Saturday Holland. A new start a new location and wow what a top location, Pathé Leidsche Rijn. A cinema with 7 screens and ranging from 180 to 668 seats....

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...

LEAP 2018

Lead Enterprise Architect ProgramFrom the 4th of December until the 6th of December I've joined the LEAP (Lead Enterprise Architect Program) 2018 Data/AI from Microsoft NL. Three  days on the Microsoft Campus in Redmond joining business and technical sessions from a...

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...

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

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...

Azure Data Factory: Save a pipeline as a Template

Saving a PipelineAnother great improvement in Azure Data Factory. Saving you template!How can you save your template? First of all you need to connect your Azure Data Factory to  a GIT integration. Both Azure DevOps GIT and GitHub are supported. Please follow this...

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

Collection of all ADF Mapping Data Flow videos

ADF Mapping FlowDid 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...

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...

ADF: Get Metadata Activity stopped working

Meta Data ActivityToday my pipelines in Azure Data Factory (ADF) suddenly stopped working. The output structure was not found. Quit strange while these pipelines have been running for weeks.    Invalid Template After debugging my Pipeline I found out the...

LEAP 2018

Lead Enterprise Architect ProgramFrom the 4th of December until the 6th of December I've joined the LEAP (Lead Enterprise Architect Program) 2018 Data/AI from Microsoft NL. Three  days on the Microsoft Campus in Redmond joining business and technical sessions from a...

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...

Microsoft Build 2022 Book of News

Microsoft Build 2022MSBuild 2022 has just started. A lot of new Announcement will be released or demonstrated the upcoming days. Like every year or event most of these announcement are added to the Book of News.The book of news can be downloaded from the link below...

Enable Pattern Rules in Azure Purview

How can I enable Pattern Rules?​Pattern Rules Last night I was preparing for a demo with Azure Purview. As always, I walk through all the activity hubs to see if there are any new options. This time I noticed that the Pattern Rules option was greyed out. Resource Set...

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

Updated competency exams and certifications Data Platform and Data Analytics for 2020

Retiring and new exams and certifications as of June 30 2020 A lot of Exams and certifications for Data Platform and Data Analytics are retiring on June 30 2020. All retired Exams and certifications will remain eligible for competency attainment and renewal until June...

Are you using Azure DevOps?

Azure DevOpsMore 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...

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...

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...

How to check your SQL Server Quota in Azure?

Azure Subscription Usages for SQL Server  Last week we reached our Logical server Quota in Azure. By default you're only allowed to add 20 Logical Servers, but we wanted to have some more for testing purposes.Microsoft Support You can submit a support ticket trough...

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....

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...

Microsoft Fabric pricing (Preview)

Microsoft Fabric PricingMicrosoft Fabric pricing in Public Preview is announced as of the 1 st of June.These are currently the Pay as You go pricing, later this year the Azure Reservation will follow. OneLake storage pricing is comparable to Azure ADLS (Azure Data...

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...

Data Factory Pricing

Data Factory pricingAre you also having problems to understand the Pricing Model for Azure Data Factory? After some research on the internet I came across an article which I wanted to share with you. ADFV2 Pricing ExamplesFeel free to leave a comment

Read More

Upcoming Events