Forum Discussion

malheirosJordan's avatar
malheirosJordan
Icon for Advocate I rankAdvocate I
1 year ago
Solved

KQL json mapping from Date Pipeline

Hi everyone. I’m running into an issue when ingesting data from MongoDB into my Kusto database using Azure Data Factory’s Copy Activity. Two of the fields in my source collection are Unix timestamps...
eventhouse
kql database
kql queryset
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi malheirosJordan,

     

    Thank you for reaching out to Microsoft Fabric Community Forum.

     

    Azure Data Factory currently supports only CSV ingestion mappings when using Copy Activity to load data into Kusto. JSON ingestion mappings aren't supported in the sink settings for this scenario.

    To proceed, you'll need to convert the MongoDB data into CSV format and then use a corresponding CSV ingestion mapping on your Kusto table for proper column handling.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!


    Regards,
    Vinay Pabbu

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi malheirosJordan,


I just wanted to follow up on your thread. If the issue is resolved, it would be great if you could mark the solution so other community members facing similar issues can benefit too.
If not, don’t hesitate to reach out, we’re happy to keep working with you on this.

 

Regards,

Vinay Pabbu

malheirosJordan's avatar
malheirosJordan
Icon for Advocate I rankAdvocate I
1 year ago

Sorry for the delay. I guess i will try out the csv mapping and see if it works. But thanks!