How to Execute DROP VIEW Command in Synapse Notebook with SQL Serverless Pool Connection?

Hi @MulluriNivas-6816

Thank you for your question!

It looks like the issue might be related to the connection setup between your Synapse Notebook and the SQL Serverless Pool. Here are some steps to verify and correct the connection:

Verify the JDBC Driver and Connection String:

Ensure you are using the correct JDBC driver and connection string for SQL Serverless Pool. Below is an example connection string that you can use in your notebook:

server = '<serverName>-ondemand.sql.azuresynapse.net'  # Replace <serverName> with your Synapse workspace name
port = 1433
database = 'db'  # Replace 'db' with your database name

jdbc_url = f"jdbc:sqlserver://{server}:{port};databaseName={database};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30"

Make sure:

• The <serverName> matches your Synapse workspace name.
• The database name (db) corresponds to the correct SQL Serverless Pool database.

Set Up the Connection in Synapse Notebook:

Ensure that your notebook is correctly configured to use this connection string when executing SQL commands. This might involve setting up a Spark session or specifying the driver explicitly if needed.

Check for Required Drivers:

Ensure the appropriate JDBC driver is installed and available in the environment. For Azure Synapse, use the Microsoft JDBC Driver for SQL Server. You can download the latest version from Microsoft JDBC Driver.

Permissions and Pool Configuration:

Make sure:

• Your account has sufficient permissions to execute DROP VIEW.
• You are connected to the correct database and SQL Serverless Pool.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.