From the course: Microsoft Fabric Data Flows and Data Storage

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Using SQL endpoints

Using SQL endpoints - Microsoft Fabric Tutorial

From the course: Microsoft Fabric Data Flows and Data Storage

Start my 1-month free trial Buy for my team

Using SQL endpoints

“

- [Instructor] SQL endpoints can be used to access any of the data that you have in a lakehouse and a management tool, such as SQL Server Management Studio or Azure Data Studio, in addition to the built-in Fabric SQL Query Editor. A SQL endpoint is created automatically every time you create a data lakehouse, and the endpoint is then used to query the data in that lakehouse. You can use these tools to query the data using Transact-SQL, the version of SQL used with Microsoft SQL Server. You can use these management tools to create store procedures, views, or query the data. The data itself is read only. You cannot edit the data as that task needs to be completed within Fabric, perhaps by creating a Dataflow Gen2 task as we discussed in the last module. Within Microsoft Fabric, if I want to query the data in my lakehouse using T-SQL and the Fabric Query Editor, all I need to do is double click on any SQL endpoint.…

Contents