topic Re: KQL Databases. How to keep and reuse easily my queries ? in Data Engineering

KQL Databases. How to keep and reuse easily my queries ?

omarecd — Thu, 09 Jan 2025 10:38:25 GMT

Hello team.
I had all my queries in 1 single tab, I was doing a backup of that tab with all my queries often. Af some point it happened that the queryset appeared empty. Am I doing something wrong ?

Should I go, open that file and do the manual copy/paste of my queries when this happen ? Is there another better way ?

Thanks in advance.

Omar C.

Re: KQL Databases. How to keep and reuse easily my queries ?

omarecd — Fri, 10 Jan 2025 09:48:46 GMT

Adittionally, very often I do not have the option to save my queries...

Sometimes I can save them as JSON file, but not always...

Any idea why ?

Thanks in advance.

Re: KQL Databases. How to keep and reuse easily my queries ?

v-priyankata — Fri, 10 Jan 2025 10:16:23 GMT

Hi @omarecd ,

We are grateful for your participation in the Microsoft Fabric Community forum.

If your session disconnects or times out, your queries might disappear. To prevent this, save your queries regularly using the Saved Queries feature in the platform. Use the Saved Queries feature in Kusto to store your queries directly in the platform, ensuring they’re safe and accessible.
Storing queries in a browser tab can be risky due to cache clearing, accidental refreshes, or crashes. It's a good idea to back up your queries in a text file or a version-controlled system, like Git.
Copying and pasting all your queries into one tab can lead to accidental overwriting or deletion. Organize them into smaller sections or separate files to reduce the risk of losing everything.
Always back up your queries externally in a more permanent location, like a file on your computer or cloud storage, so they’re safe even if something goes wrong.
Consider using Notebooks to keep your queries organized. It’s a more structured way to manage them and reduces the chances of losing work.

If you have any questions, please feel free to reply by looping me. If you found this helpful, kindly mark it as the solution. A kudos would be greatly appreciated!

Thanks,
Priyanka.

CST community member.

Re: KQL Databases. How to keep and reuse easily my queries ?

omarecd — Fri, 10 Jan 2025 17:13:07 GMT

Hello Priyanka.

Thanks for the valuable feedback.

Just to make sure that I understood correctly, what you mentioned "Saved Queries" feature in the platform is what is here reflected as KQL Query set ?

You mentioned notebooks. I was thinking that Notebooks were fopr Spark (python, etc) but not for KQL. Can I have a notebook where I write my KQL queryes ? I haven't see this...

Thanks in advance.

Re: KQL Databases. How to keep and reuse easily my queries ?

v-priyankata — Sun, 08 Jun 2025 21:17:08 GMT

Hi @omarecd

Thank you for using Microsoft Community Forum. Sorry for the late reply!

That green box you pointed out is basically where you save and organize your queries. It’s like the platform’s version of “Saved Queries,” so you can keep your work safe and easy to reuse.
Platforms like Azure Data Explorer and Microsoft Fabric let you create notebooks for KQL too. It’s a great way to keep queries, explanations, and visuals all in one spot.
If you don’t see the notebook option, it might just not be enabled for your setup yet. Sometimes it depends on your environment or admin settings.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

Re: KQL Databases. How to keep and reuse easily my queries ?

v-priyankata — Thu, 12 Jun 2025 09:14:38 GMT

Hi @omarecd

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: KQL Databases. How to keep and reuse easily my queries ?

v-priyankata — Mon, 16 Jun 2025 04:55:06 GMT

Hi @omarecd
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution.
Thank you.

Re: KQL Databases. How to keep and reuse easily my queries ?

maknid — Thu, 09 Apr 2026 10:34:09 GMT

Yes, I am able to see the option to save the query but not sure how to see the saved ones.