Forum Discussion

Tzvia's avatar
Tzvia
Icon for Microsoft rankMicrosoft
Sep 13, 2018

Welcome to Azure Data Explorer (Kusto) Space

Welcome to the Azure Data Explorer (Kusto) space @ TechCommunity. Join us to share questions, thoughts or ideas about Kusto and receive answers from the diverse Azure Data Explorer community.

 

Our community is here to assist you with any question or challenge such as creating a new Data Explorer cluster, database or table, ingesting data or performing a complex query.

 

Learn more about Data Explorer (Kusto):

  1. Azure Data Explorer
  2. Documentation
  3. Course – Basics of KQL
  4. Query explorer
  5. Azure Portal
  6. User Voice
  7. End to End Lab
  8. Azure Data Explorer Blog

 

Investigate your data with Azure Data Explorer (Kusto).

Question, comment or request? Post it here.

 

BR,

Azure Data Explorer product team

15 Replies

  • snteran's avatar
    snteran
    Copper Contributor

    Tzvia 

     

    We ran into a row limitation within security.microsoft.com > advanced hunting.  We can only get 10,000 rows and we heard if you connect to PowerBI, you could get up to 100,000 rows.  However I'm not sure how we go about selecting our cluster within security.microsoft.com to connect using the Azure Data Explorer (Kusto).  Perhaps that not the right way to go about getting the data we need but it was a recommendation from a MS rep.

     

    Cheers,

    Serge

  • lmaher's avatar
    lmaher
    Copper Contributor

    Tzvia 

    I am new to Kusto and I would like to know more about JOIN specially when joinning multiple tables together cause I always get an empty result.

    • Tzvia's avatar
      Tzvia
      Icon for Microsoft rankMicrosoft

      lmaher 

       

      Hey 

      I assume you already read the relevant documentation 

      did you tried the free online courses with explanation on the most used operators ? 

       

      would you like to add your query we may be able to identified the error?

       

       

  • lmaher's avatar
    lmaher
    Copper Contributor

    Tzvia I am new to Kusto and I receive the message "Partial query failure: Low memory condition (Message: 'Bad allocation')" in many cases some of them are related to JOIN and actually I don't know what is the meaning of it and how to avoid it.

    • Tzvia's avatar
      Tzvia
      Icon for Microsoft rankMicrosoft

      the online courses will answer those questions, did you did them ?lmaher 

      • lmaher's avatar
        lmaher
        Copper Contributor

        Hi Tzvia

         

        I am sorry I was quite busy the last few days, I will check the Online courses and get back to u. 

         

        I really appreciate ur message 🙂 

         

        Regards,

         

  • Kamlesh Kumar's avatar
    Kamlesh Kumar
    Bronze Contributor
    Very informative and we would love to explore this. Thanks for sharing this at one place.
  • Tzvia 

    Appreciate if you can throw some light on "how to decide between Azure Data Explorer and Time Series Insights".  Are there any guidelines and sample use cases which can provide us a better understanding while selecting one over the other.

  • ITconnecter's avatar
    ITconnecter
    Copper Contributor

    Great stuff, thank you! 

    Quick question, for an SMB business who will have their data in Office (on-prem or Office365) and possibly in a 3rd party app (e.g. Quickbooks), would there be a tutorial about the process to identify, rationalize, normalize and then centralize all this data using Kusto and/or KQL?  The goal would be to create an SMB's data repository on Azure for backup/DR/BCP/GDPR compliance, etc.

     

    Best,

    Gates Ouimette

    ITconnecter

  • Drew Flint's avatar
    Drew Flint
    Copper Contributor

    Thanks for pulling all this information into one space. It's really exciting to see the capabilities of Data Explorer and learn more about the Kusto query language.

Resources