Fabric: Query a SQL Endpoint from a Notebook


 

Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can dig into how to make a query to a SQL Endpoint.

We use notebooks to connect directly to lakehouse. Except by the T-SQL notebook, the notebooks have a default lakehouse and work directly with it from spark. However, accessing other data object may be more complex

Why execute a Query on a SQL Endpoint from a Notebook

The reasons to query a SQL Endpoint from a notebook are not very usual, but there are many.

Most data objects have a SQL Endpoint: