Using SQL Server Management Studio (SSMS) to connect to a data warehouse in Fabric can facilitate your workflow, especially if you’re already familiar with the tool.
Connect to your data warehouse
SQL Server Management Studio provides a familiar interface for those who regularly work with SQL Server.
Follow these steps to connect to data warehouse in Fabric from SSMS:
- Navigate to your Microsoft Fabric workspace.
- On your warehouse asset, select more options, then select Copy SQL connection string.
- Launch SQL Server Management Studio, and paste the SQL connection string copied into the Server name box, and provide the appropriate credentials for authentication.
- After establishing a connection, SSMS shows the connected warehouse, along with its corresponding tables and views, all ready for querying.
Authentication options
In Microsoft Fabric, two types of authenticated users are supported through the SQL connection string:
- Microsoft Entra ID (formerly Azure Active Directory) user principals, or user identities
- Microsoft Entra ID (formerly Azure Active Directory) service principals
Leave a Reply