ADF Dynamic folder creation at Sink ADLS

ADF Dynamic folder creation at Sink ADLS

We have creating dynamic folder in ADLS through ADF then we have to use Dynamic expression at sink side.

For Folder creation with year month and date folder, In File Path we have to mention below one

                               @concat('ParentFolderName','/','ChildFolderName','/', formatDateTime(utcnow(), 'yyyy'), '/', formatDateTime(utcnow(), 'MM'), '/', formatDateTime(utcnow(), 'dd'), '/')

 

and For File Name creation with TimeStamp, In File Path second section we have to mention below one

                               @concat('FileName_',formatDateTime(utcnow(), 'yyyyMMddTHHMMss'))

To view or add a comment, sign in

More articles by Amit Kumar

  • Databricks Workflows : Schedule and orchestrate

    When working with data, it is very useful to be able to create data pipelines. In a data pipeline, we can have…

  • Medallion Architecture

    What is a medallion architecture? With the aim of gradually and progressively enhancing the structure and quality of…

  • XML Parsing from URL

    Parsing an XML file is easy thanks to the ElementTreet module from Python’s standard library. What is XML? XML…

  • Parsing nested JSON lists by Python

    Parsing complex JSON structures is usually not a trivial task. When your destination is a database, what you expect…

Explore content categories