How to setup Source control in Azure Data Factory

Step by Step guide

You can either configure source control at the time of ADF deployment or can keep it for later.

If you prefer to set up later Check Configure Git later in the Git Configuration tab and proceed. In this blog, we will set it up later.

Now let us set up source control in already deployed ADF resource. Navigate to your Data factory UI, click on the drop-down next to the Data Factory icon, and set up a code repository.

Let us consider only Azure DevOps Git in this blog.

Nest step is to choose the mode of linking your Azure integrated Git with ADF. You can either choose.

Select repository or Use repository link

Select repository option allows you to provide repository names and Use repository link enables you to use URL link in Project to connect repository for ADF source control.

Picture

You need to set up the Azure DevOps project in Azure DevOps Organizations. Without this, you will not get any options in the dropdown shown in the Picture.! Check this to understand AzureDevops organization

Tip**** Make sure you sign out and sign in again, after clearing your browser cache in case you are not getting the Project name under the Azure Dev Ops organization you selected. This generally happens if you are configuring the DevOps project in parallel with ADF git setup and the browser cache is stale.

Common Errors

Verify that your Azure DevOps account is connected to the AAD account, the Azure DevOps repository is in the Default Directory (bla..bla..bla) tenant, and that your current ADF user account has been added to the Azure DevOps organization.

You can fix it by connecting the Azure Active directory used in your ADF resource to Azure DevOps Organizations. Follow the below steps.

Login to Azure DevOps Organization → Organization Settings → Overview→ Azure Active Directory → Connect directory

If you have not received any errors then you are through and have successfully configured Azure DevOps Git in your ADF. Below is a picture how your current setup should look like in an ideal case.

The Collaboration branch is the one used to push code to Other Data factory instances - DEV to QA for instance.

You can follow general best practices such as 'always create a feature branch for new enhancements' and 'never directly push to masters' or follow any policies designed by your organization.

Save in data factory will act as commits in Azure Git Repo's working branch.

The picture above shows how you can toggle between different branches.

adf_publish branch has the ADF ARM template, which is used for Code Migrations.

*** You can also disconnect Git Repository from Source Contol in Management Hub.

Comments

How to work with XML files in Databricks using Python

This article will walk you through the basic steps of accessing and reading XML files placed at the filestore using python code in the community edition databricks notebook. We will also explore a few important functions available in the Spark XML maven library. Think of this article as a stepping stone in the databricks community edition. Features and functionalities elaborated herein can be scaled at the enterprise level using Enterprise editions of databricks to design reusable file processing frameworks. Requirements We will be using the Spark-XML package from Maven. **Spark 3.0 or above is required on your cluster for working with XML files. This article uses Databricks Community edition, refer to this video tutorial from Pragmatic works for getting started with Databricks Community Edition . Create your first cluster in seconds : The next step is to install the Spark-XML library on your cluster. The cluster needs to be in a running state to install this li...

Microsoft Fabric

Complete Analytics Platform In its new Software as a service offering, Microsoft basically clubbed every tool in their Analytics portfolio and gave it a new name - Fabric :). Claims are Fabric can serve every Data stakeholder ranging from a developer working with Data Lake to a Sales associate working on a self-serve Powerbi report. Microsoft has implemented tenant centric architecture in Fabric like office 365, In optimal design an organization will have 1 fabric similar to 1 office 365 tenant for entire organization. Lake centric and Open All the data and apps built on Fabric provided solutions will get stored at a single lake, It auto calculates the lineage for objects stored on a single data lake. It uses delta file format and parquet data storage for all the objects. Advantage: Table storage is shared across the fabric workspace, suppose you have a data issue in a Synapse datawarehouse query, just run a fix on the data set using Synapse data engineering python not...

Hierarchies in Oracle.

This article explores the functionality and features offered by CONNECT BY clause in Oracle with a hands-on exercise approach. Prerequisite: Oracle 9g or lastest installed, any oracle SQL client. We have used Oracle's sample schema for this article, you can download it too from the link below. Execute this SQL in your oracle client and you should be all set with data and schema. https://download.oracle.com/oll/tutorials/DBXETutorial/html/module2/les02_load_data_sql.htm Let's get started with CONNECT BY clause in Oracle. This is basically an oracle clause to place eligible datasets in a hierarchical fashion. Meaning, usage of this function is generally for creating a new resultant query that will elaborate hierarchical relations in a table. Here is the basic syntax [ START WITH condition ] CONNECT BY [ NOCYCLE ] condition START WITH is an optional keyword that can be used as a starting point for hierarchy. CONNECT BY describes the relationship between a child and parent r...

StoredProcs

Search This Blog