We are currently trying to access our built-in serverless SQL pool from our notebook. Our goal is to be able to drop views from the notebook, which is something we need to put into our pipeline as per our business requirements. We have attempted several methods but have not yet succeeded.

I’m working with Azure Synapse Analytics and I need to connect my Synapse Notebook to my SQL Serverless Pool to drop and create views directly within the notebook. However, when I try to run the DROP VIEW command within the notebook without explicitly establishing a connection, I receive the following error:

I’m attempting to store the top 100 rows of a view from an SQL database to a dataframe using Synapse Notebook. I have tried using this code: