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

[omarecd]

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.

[v-priyankata]

Hi @omarecd ,

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

1. 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.
2. 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.
3. 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.
4. 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.
5. 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.

[omarecd]

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.

[v-priyankata · Accepted solution]

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.

[v-priyankata]

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.

[v-priyankata]

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.

[omarecd]

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.