Business Intelligence, Data Warehouse and Data Lake

SQW08 Data Exploration with Synapse and KQL


4:00pm - 5:15pm

Level: Introductory

Kevin Feasel


Catallaxy Services, LLC

With Data Explorer pools, Azure Synapse Analytics now supports the Kusto Query Language (KQL). Originally designed for log analysis, KQL is also a great fit for time series analysis. If you're familiar with T-SQL but have not looked at KQL, let's come together and see how the language works. We will learn how to ingest data into a Data Explorer database and then query and visualize this data using Power BI.

You will learn:

  • Where Data Explorer pools fit into the Synapse ecosystem
  • See how Data Explorer pools are useful for more than log analysis
  • The basics of the Kusto Query Language (KQL)