Home
%3CLINGO-SUB%20id%3D%22lingo-sub-1214496%22%20slang%3D%22en-US%22%3EComing%20soon%20to%20Azure%20Data%20Factory%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1214496%22%20slang%3D%22en-US%22%3E%3CP%3EStarting%20next%20week%20in%20Azure%20Data%20Factory%2C%20you%20will%20see%20the%20following%20updates%20to%20Azure%20Data%20Factory!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EFlatten%26nbsp%3B%3C%2FSTRONG%3E%3CSTRONG%20style%3D%22font-family%3A%20inherit%3B%22%3Etransformation%20in%20mapping%20data%3C%2FSTRONG%3E%20%3CSTRONG%20style%3D%22font-family%3A%20inherit%3B%22%3Eflow%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%20the%20new%20flatten%20transformation%20to%20denormalize%20your%20hierarchical%20arrays%20.%20Select%20an%20array%20to%20unroll%20into%20individual%20rows.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Flattenguide.png%22%20style%3D%22width%3A%20984px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F175705i9CBE8947BCC37C7F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Flattenguide.png%22%20alt%3D%22Flattenguide.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThis%20transformation%20will%20be%20found%20under%20'Schema%20modifiers'.%20For%20more%20information%2C%20see%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fdata-flow-flatten%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eflatten%20transformation%20documentation.%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EDynamic%20content%20in%20wait%20activity%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%20expressions%2C%20variables%20and%20parameters%20to%20dynamically%20evaluate%20the%20'wait%20time%20in%20seconds'%20field%20of%20the%20wait%20activity.%20No%20longer%20do%20you%20have%20specify%20a%20hard%20coded%20value.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22wait-expression.png%22%20style%3D%22width%3A%20708px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F175703i091689826DA0D696%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22wait-expression.png%22%20alt%3D%22wait-expression.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EPublishing%20improvements%20in%20'Data%20Factory'%20mode%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20not%20configured%20to%20a%20git%20repository%2C%20you%20will%20now%20see%20a%20list%20of%20edited%20resources%20when%20clicking%20'Publish%20all'.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22publish.png%22%20style%3D%22width%3A%20946px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F175704i38455B21AAD4ADF9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22publish.png%22%20alt%3D%22publish.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditordaperlov_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditordaperlov_2%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3EThis%20has%20been%20available%20when%20git%20is%20configured%20for%20some%20time.%20For%20more%20information%2C%20see%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fsource-control%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Esource%20control%20in%20ADF%3C%2FA%3E%26nbsp%3B.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EImprovements%20to%20tumbling%20window%20trigger%20dependency%20monitoring%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditordaperlov_1%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3ETwo%20improvements%20have%20been%20made%20to%20the%20tumbling%20window%20trigger%20monitoring%20experience.%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CDIV%3EThe%20list%20view%20for%20tumbling%20window%20trigger%20dependencies%20now%20displays%20the%20same%20information%20as%20the%20Gantt%20view%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22twt2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F175712iE7C3A8749DF85A76%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22twt2.png%22%20alt%3D%22twt2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3C%2FLI%3E%0A%3CLI%3E%3CDIV%3EThe%20Gantt%20chart%20will%20display%20timestamp%20for%20individual%20windows%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22twt1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F175713i3471046C58A72DAA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22twt1.png%22%20alt%3D%22twt1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EFor%20more%20information%2C%20see%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Ftumbling-window-trigger-dependency%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Etumbling%20window%20trigger%20dependency%20documentation%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20a%20feature%20request%20for%20ADF%2C%20post%20on%20%3CA%20href%3D%22https%3A%2F%2Ffeedback.azure.com%2Fforums%2F270578-data-factory%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eour%20feedback%20forum%3C%2FA%3E!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1214496%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20out%20the%20upcoming%20new%20features%20in%20Azure%20Data%20Factory%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ENew%20flatten%20transformation%20in%20mapping%20data%20flow%3C%2FLI%3E%0A%3CLI%3EImprovements%20to%20publishing%20without%20a%20git%20repository%3C%2FLI%3E%0A%3CLI%3EDynamic%20content%20in%20the%20wait%20activity%3C%2FLI%3E%0A%3CLI%3EImprovements%20to%20tumbling%20window%20trigger%20dependency%20monitoring%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1214496%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMapping%20Data%20Flows%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

Starting next week in Azure Data Factory, you will see the following updates to Azure Data Factory!

 

Flatten transformation in mapping data flow

 

Use the new flatten transformation to denormalize your hierarchical arrays . Select an array to unroll into individual rows.Flattenguide.png

This transformation will be found under 'Schema modifiers'. For more information, see the flatten transformation documentation. 

 

Dynamic content in wait activity

 

Use expressions, variables and parameters to dynamically evaluate the 'wait time in seconds' field of the wait activity. No longer do you have specify a hard coded value.

 

wait-expression.png

Publishing improvements in 'Data Factory' mode

 

When not configured to a git repository, you will now see a list of edited resources when clicking 'Publish all'. 

publish.png

 
 

This has been available when git is configured for some time. For more information, see source control in ADF .

 

Improvements to tumbling window trigger dependency monitoring

 

Two improvements have been made to the tumbling window trigger monitoring experience.

  • The list view for tumbling window trigger dependencies now displays the same information as the Gantt viewtwt2.png
  • The Gantt chart will display timestamp for individual windowstwt1.png

For more information, see the tumbling window trigger dependency documentation.

 

If you have a feature request for ADF, post on our feedback forum!