Home
%3CLINGO-SUB%20id%3D%22lingo-sub-955958%22%20slang%3D%22en-US%22%3EAzure%20Data%20Factory%20Mapping%20Data%20Flows%20for%20U-SQL%20Developers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-955958%22%20slang%3D%22en-US%22%3E%3CP%3EU-SQL%20is%20an%20ETL%20coding%20environment%20that%20executes%20on%20Azure%20Data%20Lake%20Analytics.%20Azure%20Data%20Factory%20now%20includes%20code-free%20transformation%20at%20scale%20with%20Mapping%20Data%20Flows.%20Here%20are%20a%20few%20examples%20of%20how%20to%20migrate%20from%20U-SQL%20to%20ADF%20Data%20Flows%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252FFe7M8dG7JQ4%253Ffeature%253Doembed%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253DFe7M8dG7JQ4%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252FFe7M8dG7JQ4%252Fhqdefault.jpg%26amp%3Bkey%3Db0d40caa4f094c68be7c29880b16f56e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22400%22%20height%3D%22225%22%20scrolling%3D%22no%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%20title%3D%22Video%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EIn%20this%20video%20tutorial%2C%20I%20walk%20you%20through%20migrating%20from%20%3CA%20href%3D%22https%3A%2F%2Fwww.sqlservercentral.com%2Fsteps%2Fstairway-to-u-sql-level-2-breakdown-of-a-u-sql-statement%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMike%20McQuillan's%20U-SQL%20ETL%20tutorial%20from%20SQL%20Server%20Central%3C%2FA%3E.%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fkromerbigdata.com%2F2019%2F03%2F03%2Fu-sql-searchlog-aggregations-as-adf-data-flows%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EIn%20this%20example%3C%2FA%3E%2C%20I%20show%20you%20how%20to%20migrate%20the%20U-SQL%20web%20search%20logs%20analytics%20sample%20into%20ADF%20Data%20Flows.%3C%2FLI%3E%0A%3CLI%3EThere%20is%20also%20a%20U-SQL%20as%20Data%20Flow%20pipeline%20template%20built%20into%20ADF.%20Go%20to%20the%20ADF%20UI%20and%20select%20new%20%22pipeline%20from%20template%22.%20Choose%20the%20Data%20Flows%20category%20and%20click%20%22Data%20Flow%20Search%20Log%20Analytics%22.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F151280iE5746EC42C5925E4%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThis%20will%20add%20a%20Data%20Flow%20and%20pipeline%20to%20your%20factory%20that%20is%20taken%20from%20this%20U-SQL%20sample%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-lake-analytics%2Fdata-lake-analytics-u-sql-get-started%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-lake-analytics%2Fdata-lake-analytics-u-sql-get-started%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-955958%22%20slang%3D%22en-US%22%3E%3CP%3EExamples%20of%20how%20to%20build%20Data%20Flows%20using%20ADF%20for%20U-SQL%20developers%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-955958%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20ETL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMapping%20Data%20Flows%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

U-SQL is an ETL coding environment that executes on Azure Data Lake Analytics. Azure Data Factory now includes code-free transformation at scale with Mapping Data Flows. Here are a few examples of how to migrate from U-SQL to ADF Data Flows:

 

 

  1. In this video tutorial, I walk you through migrating from Mike McQuillan's U-SQL ETL tutorial from SQL Server Central.
  2. In this example, I show you how to migrate the U-SQL web search logs analytics sample into ADF Data Flows.
  3. There is also a U-SQL as Data Flow pipeline template built into ADF. Go to the ADF UI and select new "pipeline from template". Choose the Data Flows category and click "Data Flow Search Log Analytics".

clipboard_image_0.png

This will add a Data Flow and pipeline to your factory that is taken from this U-SQL sample: https://docs.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-u-sql-get-started