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: