How to customize the name of file in export command in Azure data explorer

siddharth bansal 346 Reputation points
2023-07-20T10:17:40.9866667+00:00

I am exporting data to blob storage using the .export command , i want the the file name to be <TableName>_<today'sDateTime> but i am unable to change the file name in namePrefix property of .export command and cannot find any specific information in the docs available .

kindly suggest a way to achieve the goal .

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
537 questions
{count} vote

Accepted answer
  1. KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee
    2023-07-22T17:32:59.92+00:00

    @siddharth bansal Welcome to Microsoft Q&A forum and thanks for reaching out here.

    Update on July 25th 2023 : I

    I had a confirmation from ADX product team that when trying to export to a blob, it is not possible to dynamically add the tablename and datetime for the filename prefix. namePrefix only accepts static value.
    I would recommend you to please submit a feature request in ADX ideas forum here: https://feedback.azure.com/d365community/forum/a952add5-eb24-ec11-b6e6-000d3a4f0da0

    Please do share the feedback link once it is posted so that I can share it with respective product owners for further review. All the feedback shared in this forum are actively monitored and reviewed by respective product owners.

    Update on July 22nd 2023: Are you just trying to export to a blob using .export command or are you trying to export to an external table instead?

    If you are looking to export just to a blob then as per my tests, we can only hard code (static value) the "namePrefix" but I didn't find a way to make it dynamic so that it will pick the date time of the file generation.

    User's image

    I'm checking with internal team to see if there are any workarounds or hardcoding the static value for namePrefix is the only option.

    Hope this helps. Let me know if you have any questions.


    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

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