Edit

Analyze data in a KQL database

Microsoft Fabric provides a unified Analyze data with menu that gives you a consistent way to move from data to analysis across Lakehouse, Warehouse, and Eventhouse. Instead of navigating different menus for each workload, you can start your analysis from a single, predictable entry point.

From a KQL database in Eventhouse, the Analyze data with action lets you:

  • Analyze data using SQL analytics endpoint, when OneLake availability and sync are enabled.
  • Launch analysis actions from a single location, without switching contexts or reconfiguring access.

This integration provides a consistent experience regardless of where your data lives. The same Analyze data with menu is available in Lakehouse, Warehouse, and Eventhouse, so the way you analyze data looks and feels the same across all workloads. Whether you're doing exploratory analysis, advanced transformations, or experimentation, you can get started quickly from a familiar starting point.

Tip

To use KQL queries to analyze the data, use the KQL queryset embedded in your Eventhouse. See Explore your KQL database with the embedded KQL queryset.

Note

The Analyze data with menu is not available for read-only monitoring eventhouses.

Prerequisites

Analyze data by using the SQL analytics endpoint

  1. In your Fabric workspace, go to your KQL database.

  2. Select Analyze data with > SQL analytics endpoint.

    Screenshot of the **Analyze data with** button expanded with the SQL analytics endpoint option highlighted.

  3. The Lakehouse SQL analytics endpoint opens with a new Eventhouse connection.

    You can see Eventhouse in the explorer pane, where the KQL database is listed.

  4. Query the SQL analytics endpoint and analyze the data in your KQL database by using T-SQL.

Related content

  • Last updated on