Share via

Azure Data Factory: How to add Additional Ingestion Properties for Azure Data Explorer sink in the Data Flow Transformation Acitivity

Bhagyesh Patil 26 Reputation points Microsoft Employee
2021-12-09T22:11:58.273+00:00

Hi,

I want to add 'ingestion properties' to the sink 'Azure Data Explorer' during the 'Data Flow Transformation' activity. I see the option to add the 'ingestion properties' during the 'copy activity' using the property 'AdditionalProperties' (Reference: https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-data-explorer?tabs=data-factory#azure-data-explorer-as-sink), but I don't see any similar option in the 'Data Flow Transformation' activity.

How can I add the 'ingestion properties' when I am using the 'Data Flow Transformation' activity and not the 'Copy activity'?

Thanks,
Bhagyesh

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nasreen Akter 10,891 Reputation points Volunteer Moderator
    2021-12-09T23:19:06.867+00:00

    Hi @Bhagyesh Patil ,

    You can add additional columns in the CopyActivity as well as in the Dataflow. In the Dataflow, you have to add Derived Columns Activity to add additional columns and in the Sink Activity, you just have to map the newly created columns. Hope this will help. Thanks!

  2. Phan, Vinnie 1 Reputation point
    2022-10-27T11:57:01.197+00:00

    Hi,

    I want to ingest from ADF to ADX using Copy data activity. I try to setup Multijson format by using additional properties as the screenshot below. However, I can't make it work

    Instead, I use .ingest into ... with ("format"="multijson"), the same file can be ingested to ADX

    Can anyone tell me if I didn't configure ADF correctly?

    254781-image.png

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.