Build with an Azure free account. Get USD200 credit for 30 days and 12 months of free services.

Start free today

How to prepare data using wrangling data flows in Azure Data Factory

Play How to prepare data using wrangling data flows in Azure Data Factory

The Discussion

  • User profile image
    Sad

    The "Done" button after creating Merge Queries does nothing. Upon debugging receiving Sink dataset filepaths cannot contain a file name. Please remove the file name from 'WranglingFile1'. Pretty much in preview stage as it says :)

  • User profile image
    Andre

    Why is it called "wrangling data flow"? To wrangle means to quarrel or collect.

  • User profile image
    parask
    @Sad:
    The "Done" button is just an indicator for UX to know that user is done with doing the transformation. I agree that this is confusing and we are working on improving the experience.
    Regarding the sink dataset, as the error message says, the sink dataset can only contain the folder (and no file). The idea is once the transformations are run on source dataset, the ADF will create the output files in the folder specified in the sink dataset. Please remove the file name from sink dataset.
  • User profile image
    Mr TA

    This is poor design. Now I have to create 2 datasets for each blob: one without a filename for the sinks, and one with a filename for everything else. What were you thinking when you did this, Microsoft?

  • User profile image
    Siva

    There is no support for on Prem datasources such as Oracle warehouse,SQL Server ?
    I see bunch of cloud sources only

Add Your 2 Cents