The SQL Analytics Endpoint

Introduction to Microsoft Fabric

Alex Kuntz

Head of Cloud Curriculum, DataCamp

The SQL Analytics Endpoint

  • What: An experience to interact with Lakehouse data using SQL
Introduction to Microsoft Fabric

The SQL Analytics Endpoint

  • What: An experience to interact with Lakehouse data using SQL

  • Who: Data analysts for data exploration or reporting.

Introduction to Microsoft Fabric

The SQL Analytics Endpoint

  • What: An experience to interact with Lakehouse data using SQL

  • Who: Data analysts for data exploration or reporting

  • How: Created automatically with the Lakehouse. Accessed through the Lakehouse interface.

Navigating to the SQL analytics endpoint in the top right corner of the lakehouse interface

Introduction to Microsoft Fabric

Writing SQL

An example SQL query with results

Introduction to Microsoft Fabric

Read-Only

An error message saying Data Manipulation statements are not allowed

  • INSERT (a Data Manipulation statement) causes an error
Introduction to Microsoft Fabric

Lakehouses vs. Warehouses

Read-only SQL analytics endpoints created for each Lakehouse. Warehouses can use SQL for read and write access.

1 https://learn.microsoft.com/en-us/fabric/data-warehouse/data-warehousing
Introduction to Microsoft Fabric

Lakehouses vs. Warehouses

Highlighting that a lakehouse is read only using SQL

1 https://learn.microsoft.com/en-us/fabric/data-warehouse/data-warehousing
Introduction to Microsoft Fabric

Lakehouses vs. Warehouses

Highlighting that a warehouse can read and write using SQL

1 https://learn.microsoft.com/en-us/fabric/data-warehouse/data-warehousing
Introduction to Microsoft Fabric

The Visual Query Editor

  • Visual queries allow for query creation without writing SQL syntax
  • Visual query editor is also read-only for lakehouses!

An example of a query being created in the visual query editor

1 https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-sql-analytics-endpoint
Introduction to Microsoft Fabric

Let's practice!

Introduction to Microsoft Fabric

Preparing Video For Download...