You can use `explain` to translate #SQL to #KQL #Kusto.

SQL forever! :)

https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/sqlcheatsheet

New post: "Cross-Platform Compatibility Made Easy with Multi-Platform Docker Images: Azure Data Explorer Sink Connector & Kafka Connect"

Docker has revolutionized the way we package and deploy software applications.

However, it's challenging to maintain a single image that can work across multiple platforms.

This blog post explores the steps required to build and deploy multi-platform Docker images.

https://nielsberglund.com/post/2023-04-17-cross-platform-compatibility-made-easy-with-multi-platform-docker-images-azure-data-explorer-sink-connector--kafka-connect/

#kafka #azuredataexplorer #kusto #kafkaconnect

New post: "Develop a Real-Time Leaderboard Using Kafka and Azure Data Explorer - II"

This is the third post about using Kafka and @azuredataexplorer (ADX) to develop a real-time leaderboard for online gaming.

In this post, you will see more about ingesting data into ADX and some "cool stuff" related to that. Specifically, what to do if you need to update/transform the data you ingest.

https://nielsberglund.com/post/2023-04-03-develop-a-real-time-leaderboard-using-kafka-and-azure-data-explorer---ii/

#kafka #azuredataexplorer #kql #kusto

🚨 Attention all #Azure enthusiasts! 🚨 Want to learn how to easily retrieve available IP addresses in your Azure Virtual network and subnets using #AzureResourceGraph? Check out my latest blog post now!

https://stefanstranger.github.io/2023/03/29/AzureResourceGraphAvailableIPAddresses/

#kusto

I just wrote one of the most complicated #kusto queries I've written until now, retrieving the total number of available IP addresses for Azure Virtual Networks and subnets. 🎉🎉

Anyone interested in me sharing this #Azure Resource Graph Kusto query?

New post: "Interesting Stuff - Week 11, 2023".

This week:

* Learn all about @azuredataexplorer and #Kusto, thanks to Akshay Dixit.
* I finally finished the second post in the Leaderboard, Kafka, and ADX series
* ChatGPT and dialogue prompting. Very interesting
* An old colleague of mine -Ted Neward - ponders the impact of AI on developers.
* Where has all the Big Data gone?

Read all about it:

https://nielsberglund.com/post/2023-03-19-interesting-stuff---week-11-2023/

#AzureDataExplorer #KQL #kafka #kafkaconnect #AI #ml #openai

Data Analysis in @azuredataexplorer using #KQL

In this learning path, you will learn through 6 training modules, how to analyze data in #AzureDataExplorer (#ADX) using the #Kusto Query Language (#KQL).

https://learn.microsoft.com/en-us/training/paths/data-analysis-data-explorer-kusto-query-language/

(Reshared from another site 😀)

Finally, the #English #ballad serenading #kusto as the #sentinel master of data oceans

Right semi join in @AzDataExplorer
#365daysofADX Day52

Right semi-join returns all records from the right side that match a record from the left side. Only columns from the right side are returned.

Try: https://lnkd.in/dze9kFTe
More: https://lnkd.in/dBznzFTy

#Kusto #KQL #ADX

Left Semi join in @AzDataExplorer
#365daysofADX Day51

Left semi-join returns all records from the left side that match a record from the right side. Only columns from the left side are returned.

Try: https://lnkd.in/dKNy6VKd
Learn More: https://lnkd.in/dJrmh-DV

#Kusto #KQL #ADX

Using #AzureDataFactory orchestrating #Kusto query-ingest https://techcommunity.microsoft.com/t5/azure-data-explorer-blog/using-azure-data-factory-orchestrating-kusto-query-ingest/ba-p/3702143

Right Anti Join in @AzDataExplorer
#365daysofADX Day50

Right anti-join returns all records from the right side that don't match any record from the left side.

Try: https://lnkd.in/d98BhDNS
Learn More: https://lnkd.in/dKCZpyEe

#ADX #KQL #AzureDataExplorer #Kusto #Azure #Data

Left Anti join in @AzDataExplorer
#365daysofADX Day49

Left anti-join returns all records from the left side that don't match any record from the right side.

Try: https://lnkd.in/dmCi_th4
Learn More: https://lnkd.in/dXg9xTB7

#Kusto #KQL #AzureDataExplorer #Joins #SQL #NoSQL #ADX

Full outer join in @AzDataExplorer
#365daysofADX Day48

A full outer-join combines the effect of applying both left and right outer-joins.

Run the example: https://lnkd.in/d8RYX2Mb
Learn More: https://lnkd.in/dtSFEG_a

#kusto #KQL #ADX #AzureDataExplore #nosql

Create a dashboard from a query in @AzDataExplorer
#365daysofADX Day43

Dashboards are an excellent way to communicate data science insights visually. You can pin a query as a visual tile in ADX KWE

Learn More: https://lnkd.in/dH4r9NWJ

#KQL #Kusto #AzureDataExplorer #ADX #Azure

Join operator in @AzDataExplorer
#365daysofADX Day42

Merge the rows of two tables to form a new table by matching values of the specified columns from each table.

Run the sample - https://dataexplorer.azure.com/clusters/help/databases/ContosoSales?query=H4sIAAAAAAAAA3MuLS7Jz00tKuaqUcjKz8xTyM7MS7HNzMtLLVIITsxJLXZLTC5RyM9TcIYq9E6tBCotScxOVTA0AABvXAKoPgAAAA==

Learn more: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/joinoperator?pivots=azuredataexplorer

#Kusto #KQL #AzureDataExplorer #ADX

Anomaly chart in @AzDataExplorer
#365daysofADX Day41

The anomaly chart visualization is similar to a timechart, but highlights anomalies using the series_decompose_anomalies function.

Run this example - https://dataexplorer.azure.com/clusters/help/databases/Samples?query=H4sIAAAAAAAAA3WR3W7CMAyF73mKI25KpRbaTmjSUJ8CpF1WoXVptPxUifmb9vBLoGO7GFeR7ePv2I4ihpamYdToBBNLTYuqKF/zosyLdbqZqagQl/8UVV68oKreimLSdVFUDZtZR9o2WnxQ48lJ8tXsCzHM7yHMUdfidFiEN4U12AXoloUe0Turp4nYTsaeaYzs/RVedgis80CObkFdI9ltywTAagV4UtQyRKiZgyLEaTGZ9taFQqtIGHI4SX8USn4KltYEJF2YTIeFMFaHPPkMvrWOMuxFoEpDaVjujmo6aq0erafmIY+7ZCiX6wx5mSGJHb3kJA1sF8jB8q69toNwjLPkYfGTseqoja//eLNkRXXyTnuIcVyCneh72cL2YQdtDQ8ZHvIkDcsfPWH+3AvPvObx0FMXD/RLhfDYW9VhtNKwj/8U69M1b2S//AbRUQMWQQIAAA==

#KQL #Kusto #ADX
https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/visualization-anomalychart?pivots=azuredataexplorer

#Timechart in @AzDataExplorer
#365daysofADX Day40

The time chart visual is similar to a line chart except the x-axis is always time.

Syntax
T | render timechart [with ( PropertyName = PropertyValue [, ...] )]

#KQL #Kusto #ADX #AzureDataExplorer

https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/visualization-timechart?pivots=azuredataexplorer

Checkout KQL Search: http://kqlsearch.com
A aggregator for KQL Queries that are shared on GitHub by @UgurKocDe

#KQL #365daysofADX #Kusto #AzureDataExplorer
---
RT @UgurKocDe
I also want to thank the community members that share KQL Learning materials and queries with the Community:
- @reprise_99
- @rodtrent
- @kustonaut
- @BertJanCyber
- @castello_johnny
- @ep3p
- @AzDataExplorer
https://twitter.com/UgurKocDe/status/1622983034889699330

Scatter chart in @AzDataExplorer
#365daysofADX Day37

Scatter plots are used to observe relationships between variables. The scatter chart visual can also be used in the context of Geospatial visualizations.

More: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/visualization-scatterchart?pivots=azuredataexplorer

#KQL #ADX #AzureDataExplorer #Kusto