From the course: Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Using KQL to process data

Using KQL to process data - Microsoft Fabric Tutorial

From the course: Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Using KQL to process data

“

using KQL to process data. Now with the Custo Query Language, we can use this to query event houses and KQL databases, to query logs that have been streamed into those databases. Now we can use event streams to load the data into the KQL database and then start using KQL to process that data. So we could use event streams simply to get the data into the KQL database and then use the KQL language to further process the data. So with KQL transforms, we can filter. So we can use a where clause on columns. We can use project to select columns that we would like. So this is like using SELECT in a T-SQL statement. We can add extra columns. So we can add derived or calculated columns by using the EXTEND keyword. And I can use aggregations. So I can use SUMMARIZE. And I can categorize or group by by using the BIN keyword. So if we look at some common KQL syntax that we may use when processing data in a KQL database. Firstly, we can simply select from a table and count the number of rows. We…

Contents