This is just a quick post, mainly for my own reference. When working with code generated solutions we often need to convert datasets from SQL Server (T-SQL) data types to Azure Data Lake Analytics (U-SQL) data types. As you probably know U-SQL has a hybrid syntax of T-SQL and C# which uses .Net data types. … Continue reading T-SQL to U-SQL Data Type Conversion
Tag: U-SQL
Using U-SQL Split to Handle Variable Width Datasets
Happy New Year folks and welcome back to work! I hope you had a nice break. 🙂 I decided to kick off the new year of blogging with something fairly simple following some support work I did helping out a friend in the community. The problem encountered was twofold when dealing with data in Azure … Continue reading Using U-SQL Split to Handle Variable Width Datasets
Controlling U-SQL Job AU’s with Azure Data Factory v2 Pipeline Parameters
This post came about really from me playing around with Azure Data Factory Version 2 (ADFv2) and trying to gain a better appreciation of why and how you can now use parameters and expressions in ADFv2 to control your pipelines. Below is the first thing I tested out and hopefully gives you a taster of … Continue reading Controlling U-SQL Job AU’s with Azure Data Factory v2 Pipeline Parameters
Welcome to the Blog & Website of Paul Andrew 