Python 3 Script for Generating SQL Insert Statements from CSV Data

This Python 3 script is designed to take CSV file data pasted into the csv_data variable and generate SQL insert statements that can be used to insert the data into a MySQL database. The script is easy to use and can save you a lot of time when working with large amounts of data.

How to Implement CI/CD in Azure Data Factory (ADF)

Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.

Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory

Learn how to setup, configure and ingest data from Google Drive using Azure Data Factory in this step-by-step article.

The Art of Data Ingestion - Part 1

Data movement is a fundamental piece of a data engineer’s duties, and recently I’ve been thinking about the art of data movement. What are some of the most important pieces that a data engineer needs to think about when confronted with data ingestion? There is of course data exporting as well, and in that case, […]

The Assert Transformation

Migrate the SSIS Catalog in Just a Few Clicks

This wizard migrates SSIS Catalog from one server to another in just a few clicks.

Assert Transformations in Azure Data Factory

This article will show how you can use Azure Data Factory to check your data quality with an assertion.

Azure Data Factory Interview Questions and Answers

Get a few common questions and possible answers about Azure Data Factory that you may encounter in an interview.

The Script Activity in Azure Data Factory

Learn about using the Script activity in Azure Data Factory to run DDL or DML statements.

ADF Mapping Data Flow with Multiple Inputs