avatarValentin Loghin

Summary

This guide demonstrates how to connect Microsoft Fabric Lakehouse with SQL Server Management System (SSMS) for querying and browsing tables, with a prerequisite of having SSMS installed on the user's computer.

Abstract

The article provides a step-by-step tutorial for connecting to a Microsoft Fabric Lakehouse using SQL Server Management System (SSMS). It begins with opening the Sales_Gold lakehouse within the Fabric workspace and then switching to the SQL analytics endpoint. The author instructs readers to copy the SQL connection string from the lakehouse settings, launch SSMS, and use the connection string to establish a connection. Authentication is handled via Azure Active Directory with a password. Once connected, users can interact with the lakehouse as if it were a standard Microsoft SQL database, including selecting the Sales_Gold database, browsing tables, and executing queries. The guide is an extension of a previous article that showcased a medallion architecture example for the sales department using Microsoft Fabric.

Opinions

  • The author assumes that the reader has SQL Server Management System installed on their computer, indicating a target audience of database administrators or data professionals familiar with SSMS.
  • The guide implies that connecting Microsoft Fabric Lakehouse with SSMS is straightforward and similar to connecting to a traditional SQL database, suggesting that users can leverage their existing SQL skills.
  • By encouraging readers to follow and applaud the story, the author seeks validation and engagement from the audience, indicating the importance of community feedback and support in the technical writing space.

Connect Microsoft Fabric Lakehouse with SQL Server Management System(SSMS)

In this quick guide I will show you how to connect to a Fabric Lakehouse using SQL Server Management System(SSMS).

In the article Medallion architecture in Microsoft Fabric I have created an example of a Microsoft Fabric-based lakehouse medallion architecture for the sales department. In this example we will try to connect to those lakehouses using SSMS in order to browse tables and to perfom queries.

Prerequisite : SQL Server Management System must be installed on our computer.

Implementation steps :

  1. From fabric workspace we will open the Sales_Gold lakehouse.

2. Swith from Lakehouse mode to SQL analytics endpoint.

3. Chose Settings(1) from the top menu, copy SQL connection string(2)

4. Start SQL Server Mangement Studio.

5. From SSMS menu chose Connect to Server (1) , chose Database Engine for Server Type , paste SQL connection string in Server Name section, chose Azure Active Directory — Password for Authentification(3), fill the credentials (User Name & Password)(4), chose Connect (5)

6. Chose Sales_Gold database, expand Tables(2), write first query(3), execute the code (4).

We just successfully connected SSMS to Ms Fabric Lakehouse, the lakehouse can be used like a normal Ms SQL database.

If you liked this post, please show your support by 👏 for this story and follow my !

Microsoft Fabric
Data Lakehouse
Recommended from ReadMedium
avatarValentin Loghin
Integrate an Existing Data Lake to Microsoft Fabric

Today the solution we are trying to build is, we already have Data Lake that exists outside of Microsoft Fabric Lakehouse and we want to…

3 min read
avatarRK Iyer
Million Dollar Question in Microsoft Fabric — When to use Lakehouse VS Datawarehouse — Part1

FABRIC SERIES: FUNDAMENTALS 05 —DATATWAREHOUSE Vs LAKEHOUSE

8 min read
avatarAminsiddique
Modernizing Data warehouse with Databricks Lakehouse platform

Introduction:

8 min read
avatarTobias Zeulner
Introduction to Data Orchestration and Dagster

Imagine you are a developer in a software company and the research department approaches you with the following request:

17 min read
avatarJacob Rønnow Jensen
Working with JSON and nested arrays in Microsoft Fabric

As Data Engineers, we get more and more semi-structured data as input for our data warehouses, and a lot of this in the form of JSON — a…

5 min read
avatarMariusz Kujawski
Exploring the Medallion Architecture in Microsoft Fabric

The Medallion architecture stands out as one of the most popular frameworks for constructing a data lake or lakehouse. Its core concept…

9 min read