Switching Between Different Azure Databricks Clusters Depending on the Environment (Dev/Test/Prod) As far as I can gather at some point last year, probably around the time of Microsoft Ignite Azure Data Factory (ADF) got another new Activity called Switch. This is excellent and exactly what ADF needed. Nested If activities can get very messy so … Continue reading Using the Azure Data Factory Switch Activity
Tag: Azure Data Factory
Summarise An Azure Data Factory ARM Template Using T-SQL
While documenting a customers data platform solution I decided it would be far easier if we could summarise the contents of a fairly complex Data Factory using its ARM Template. So, this is what I've done using T-SQL to parse the ARM Template JSON and output of series of tables containing details about the factory … Continue reading Summarise An Azure Data Factory ARM Template Using T-SQL
Best Practices for Implementing Azure Data Factory
Blog post updated 14th August 2021 🙂 My colleagues and friends from the community keep asking me the same thing... What are the best practices from using Azure Data Factory (ADF)? With any emerging, rapidly changing technology I'm always hesitant about the answer. However, after 6 years of working with ADF I think its time … Continue reading Best Practices for Implementing Azure Data Factory
Deploying Azure Data Factory in a Single Service Environment (Option 1)
For my first appearance on the Altius Data Lounge show I talk about and demonstrate the 'out-of-the-box' capabilities within Azure Data Factory for Git integration and how to publish developed pipelines. In my demo you'll see what each of the developer UI toolbar functions means in the context of the code repository and what happens … Continue reading Deploying Azure Data Factory in a Single Service Environment (Option 1)
Get Any Azure Data Factory Pipeline Run Status with Azure Functions
Microsoft.Azure.Management.DataFactory.Models.RunFilterParameters So I recently found myself with code withdrawal… Yes, its a real thing! Anyone in an architect type role will understand, I hope… You can’t spend all your time drawing pictures of how things “should” work without occasionally getting hands-on with some code. Anyway, my recent episode of code withdrawal led me to creating … Continue reading Get Any Azure Data Factory Pipeline Run Status with Azure Functions
Azure Data Factory – Pipeline Hierarchies (Generation Control)
Best practice for structuring your Azure Data Factory? Hello friends, this post and my next few posts have been born out of a community talk I've delivered a couple of times now at various conferences. In my session I talk about using Azure Data Factory (ADF) in production - inspired by my own lessons learnt … Continue reading Azure Data Factory – Pipeline Hierarchies (Generation Control)
Azure Data Factory – Web Hook vs Web Activity
As Azure Data Factory continues to evolve as a powerful cloud orchestration service we need to update our knowledge and understanding of everything the service has to offer. Mainly, so we can make the right design decisions when developing complex, dynamic solution pipelines. In this post I want to explore and share the reasons for … Continue reading Azure Data Factory – Web Hook vs Web Activity
Using Data Factory Parameterised Linked Services
Microsoft recently announced that we can now make our Azure Data Factory (ADF) v2 pipelines even more dynamic with the introduction of parameterised Linked Services. This now completes the set for our core Data Factory components meaning we can now inject parameters into every part of our Data Factory control flow orchestration processes. Pipelines ✔ Activities … Continue reading Using Data Factory Parameterised Linked Services
Creating an Azure Data Factory v2 Custom Activity
Many moons ago and in a previous job role I wrote a post for creating an Azure Data Factory v1 Custom Activity here. According to Google Analytics this proved to be one of my most popular blog posts on that site. I therefore feel I need to do an update post with the same information … Continue reading Creating an Azure Data Factory v2 Custom Activity
What is Azure Data Factory Data Flow?
There were many great announcements to come out of the Microsoft Ignite 2018 conference, but the main one for me was the introduction of Azure Data Factory Data Flow. As a business intelligence person with many years experience working with SSIS packages this new feature is very exciting! Since I first saw the mock up … Continue reading What is Azure Data Factory Data Flow?
Welcome to the Blog of Paul Andrew 