Adding DateTime column in Azure Data Factory v2 Copy Activity Source Dataset after schema import RRS feed

  • Question

  • We have requirement to push data from CRM to Kusto database, have implemented Azure Data Factory V2  Copy Activity to push data from CRM to Kusto,

    CRM dataset has 2 columns and need to insert current datetime value as third column value in Kusto database. (there is no way to create column with default value in Kusto database)

    We have tried multiple option by adding column in source dataset, no luck.

    Please let me know any way to add one more column in source dataset after schema import from CRM. mapping that column in destination dataset (Kusto).

    Marulasiddappa SB (Swamy)

    Saturday, July 27, 2019 3:34 AM

All replies