@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-000d3a4f0da0Please 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.
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.