If you are thirsty for the solution, you can skip this part and go to the solution a bit below on the blog.
Yes, Azure Data Studio is so flexible it supports Python and we can install Python packages. However, with some help from Microsoft community on twitter I was able to find a work around: We can use KqlMagic, a Python package, to connect to Log Analytics. Of course, you already noticed how I got disappointed by discovering Azure Data Studio couldn’t connect to Log Analytics. What do you think? Let’s talk about on the comments. It puzzles me that one receives more attention than the other. On the other hand, software houses creating custom solutions or, in some situations, solution providers trying to manage a big number of clients, may find Azure Data Explorer as a better solution for them. These numbers allow the IT Administrators to do in the cloud what only a few really manage in an organized way: Keep baselines and compare results after every environment change. Log Analytics can be a fundamental tool on the process of cloud adoption, because it gives numbers to the process. On the other hand, Azure Data Explorer is a database storage MPP (Massive Parallel Processing) solution for massive stream storage – logs – allowing anyone to create their own monitoring solution using it as a storage, but not a ready-to-use solution as Log Analytics.Ĭonsidering these differences, the use cases for Log Analytics seems related to migrations to the cloud and all the following monitoring work. Log Analytics is a ready-to-use monitoring solution for cloud and on-premises environment.
All this huge focus on Azure Data Explorer given by Microsoft still puzzles me. However, Azure Data Studio only supports Kusto connections with Azure Data Explorer, not Log Analytics. That’s why Kusto was initially created for Azure Monitor and Azure Log Analytics. Kusto is a query language used for massive amounts of streamed data, perfect for logs. Recently, Azure Data Studio included the support to Kusto language, or KQL.
Connecting to Log Analytics using Azure Data Studio and KQL Simple Talk Skip to contentĪzure Data Studio is a great tool and supports way more than only SQL.