Introduction

In this tutorial, we will explain step-by-step how to query data from a Fabric lakehouse with T-SQL using an SQL analytics endpoint.

Goal

Data should be queried from a delta table in the lakehouse with T-SQL using an SQL analytics endpoint.

Data

We consider the delta table student that is stored in the lakehouse "dlnerds_lakehouse".

Step 1: Open Data Engineering Experience

We have already signed in into Fabric and opened the Data Engineering Experience. We have selected the workspace "dlnerds_workspace".

Here you can see the Data Engineering Experience.

Step 2: Open Data Lakehouse Explorer

Open the lakehouse from which you want to query data. We open the lakehouse "dlnerds_lakehouse". The lakehouse contains the delta table "student".

Step 3: Open SQL Analytics Endpoint

In order to open the SQL analytics endpoint, click on "SQL analytics endpoint" on the top right.

You are taken to the query editor of the SQL analytics endpoint.

Step 4: Create SQL Query

In order to create a SQL query, click on "New SQL query".

You can view this post with the tier: Academy Membership

Join academy now to read the post and get access to the full library of premium posts for academy members only.

Join Academy Already have an account? Sign In